Dynamic Crosstab report

[Guest]

Hi
I would like to create dynamic crosstab report which will be like this:

| Year |
Customers | Product |
| Qty | Amount |
any help and where i will get the sample reports
thans in advance.
whab

 

[Guest]

Crosstab queries in access only support un column, but you can try creating a
pivot table in excel linking to your database,

In Excel go to Data\PivotTable PivotChart, then select External data Source
and follow the wizard's instructions to connect to your access database

 

[Duane Hookom]

There are a number of crosstab report samples at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.