Dynamic Crosstab report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top