Problem with Design

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

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
 
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
Click to expand...
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
 
Back
Top