2003 Access Reports Question

[Guest]

I want to be able to populate a 2003 Access report data entirely from a
table. Including the column headers, just like a matrix.
Here is an example of what output I want to have from my report: -

Product1 Product2 Product3 etc..
Option1 5 10 2

Option2 8 1 6
Option3 1 3 8
etc...

All this data should be populate it by the query including product
names and options and quantities.

Is this possible? How?

 

[Duane Hookom]

There is a crosstab demo at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane which
provides a solution for dynamic column headings in your report.