This is a good idea. Thanks. -------------------------------------------------------- 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.
-----Original Message----- From: Baron Schwartz [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 31, 2007 3:56 PM To: Weston, Craig (OFT) Cc: mysql@lists.mysql.com Subject: Re: [mysql] crosstabs Hi, Weston, Craig (OFT) 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? The simplest way -- if you're used to Access -- is probably to use Access as the front-end and MySQL as the backend, through ODBC. Otherwise, http://www.onlamp.com/pub/a/onlamp/2003/12/04/crosstabs.html cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]