Design Problem

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

 

[Duane Hookom]

Paul,
Do you have some table structures with field names that you would like to
share? We kinda know where you want to get but have no idea where you are
starting from.

--
Duane Hookom
MS Access MVP

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