Report Design to match existing excel report

[dan dungan]

Hi microsoft.public.access.reports

I have a table called tblhistory with the following fields:

Date PartNum Rep QuoteNum Quantity UnitPrice

I need to present the daily data summarized monthly in the following
manner:

Rep 1 Rep 2
DAte # of quotes # of Items # of Quotes # of
items
10/29/07

 

[dan dungan]

I accidently sent this before I was finished.

I'm using Access 2000 on Windown XP pro.

The only way I could think of to display the data in this manner is to
use a crosstab query, but this seems awkward.

For both associates, I want to show daily:

1. how many quotes they completed
2. how many items they quoted daily
3. The amount of money they quoted daily

Please reply with your suggestions.

Thanks,

Dan Dungan

 

[Duane Hookom]

You can
- create a crosstab with multiple values
- create multiple crosstabs and join them together
- review the various crosstab reports at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[dan dungan]

Thanks Duane. I'll check them out.

Dan

You can
- create a crosstab with multiple values
- create multiple crosstabs and join them together
- review the various crosstab reports athttp://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane