Total in Report

S

ScotStuart

I have a query that produces details of the number of faxes processed by a
sales clerk for a given period. which looks like below:
[AgentName] [DateProcessed]
Agent1 01/03/05
Agent1 01/03/05
Agent1 01/03/05
Agent1 01/03/05

Agent2 01/03/05
Agent2 01/03/05
Agent2 01/03/05
Agent2 01/03/05

This query is named FaxQuery1.
I should like to produce a report like below, with a chart showing the
percentages completed per agent:

Agent1 4
Agent2 4

Can anyone assist me please?

Thanks
 
J

Jackie L

You can create a Totals query that would do this. Set it up with a Group by
for the Agent and a Count for the Date. Then on your report you can create
expressions to calculate the percentage off the Sum of the count field.

Hope this helps.
 
Top