In my opinion, the easiest way to do this would be to create a PivotTable in Excel. Excel PT's can use Access or SQL Server as the data source, and they offer far more flexibility than an Access crosstab. (In SQL Server 2000, you'd need dynamic SQL to make it work, unless you already knew all the products and years. SQL Server 2005 has the new PIVOT operator, but an Excel PT still has greater flexibility.)
Hellol matthewspatrick, Thanks for quick response.
I need this using access query as my client want and i am stuck with this in access query. Because i found many limitation in cross tab query in ms access but when i go through microsoft site they provide some way but i didn't understand to implement that in my situation.
ved17nov said: >>I need this using access query as my client want and i am stuck with this in access query.
I would urge you to have a try talking it over with your client. If they could see how much more flexible the Excel PT approach would be, they just may change their minds...
