Re: Report Design to match existing excel report
- From: dan dungan <stagerobber@xxxxxxxxx>
- Date: Thu, 6 Dec 2007 15:38:29 -0800 (PST)
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
On Dec 6, 3:33 pm, dan dungan <stagerob...@xxxxxxxxx> wrote:
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
.
- Follow-Ups:
- Re: Report Design to match existing excel report
- From: Duane Hookom
- Re: Report Design to match existing excel report
- References:
- Report Design to match existing excel report
- From: dan dungan
- Report Design to match existing excel report
- Prev by Date: Report Design to match existing excel report
- Next by Date: Re: Using VBA to manipulate Reporting
- Previous by thread: Report Design to match existing excel report
- Next by thread: Re: Report Design to match existing excel report
- Index(es):
Relevant Pages
|
