A good article on crosstab queries in MySQL is located at: http://dev.mysql.com/tech-resources/articles/wizard/print_version.html
A method of making a stored procedure based on the above article is hosted at: http://www.futhark.ch/mysql/106.html If you replace the 'sum' function with 'max' you can also create a crosstab of text values instead of simply totals. On 7/31/07, Weston, Craig (OFT) <[EMAIL PROTECTED]> wrote: > > 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. >