Problem with Design

[pas926]

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. 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.00

 

[kip]

-----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. Thanks in advance. Paul

monday tuesday wednesday Total
Sales 20.00 23.00 34.00 77.00
Tax 3.00 6.00 9. ..00 18.00
.

Paul,

You need to be a little more specific. What are you
starting from? Do you have a table of invoices? Do you
have anything yet or are you just planning whether to do
it in Access or Excel?

Kip

 

[pas926]

I'm using an Access 2000 query for my source. Thanks again Paul