Problem with Design

[Guest]

I want to create a report in the following layout using Access 2000 or Excel 2000. It seems so simple but I'm so stuck!!! Any help is greatly appreciated. I have tried using pivot form and then using excel but am still lost. I'm using a query from Access 2000 as the source for the fields. Thanks in advance. Pau

monday tuesday wednesday Tota
Sales 20.00 23.00 34.00 77.0
Tax 3.00 6.00 9.00 18.0

 

[Paul Falla]

Dear Paul

Try exporting the data from Access as a flat data set (IE
not as a crosstab). Once imported into excel open a new
worksheet and do the pivot based on the new excel data.
Alternatively, if you want the data to be --live-- then
using the pivot table wizard, select the external data
option and then link to the access table that holds the
data that you want to report on. HTH
Paul

-----Original Message-----
I want to create a report in the following layout using

Access 2000 or Excel 2000. It seems so simple but I'm so
stuck!!! Any help is greatly appreciated. I have tried
using pivot form and then using excel but am still lost.
I'm using a query from Access 2000 as the source for the
fields. Thanks in advance. Paul