The pivot function needs to be improved to not require knowledge of the columns beforehand. Access had this feature a long time ago and sometimes you don�t know what the columns will be in advance.
Upvotes: 7<=-=Jan 14 2011 2:57PM=-=>
Thanks for your feedback. This request is already being tracked by the connect item below:
Umachandar, SQL Programmability Team