In Access, designing a "crosstab" query is fairly straight forward. You just choose "crosstab" in the query design form. Is there some simple way to replicate this functionality within mysql?
Thanks, Craig -------------------------------------------------------- This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.