How do I build Expression to filter dates in a form?

[Guest]

Hi
I have a table that lists all transactions completed by agents this year so
far.
How can I get ACCESS to show the results in a form that would sort the
daily totals of completed transactions by agents per week? Fields are titled
"DATECOMPLETED" and "AGENT NAME", and hopefully produce something that looks
like example below:
Date Completed
Agent 1 28/03/05 15
29/03/05 10
30/03/05 10
31/03/05 15
01/04/05 10
Total Week 60
Agent 2 28/03/05 15
29/03/05 10
30/03/05 15
31/03/05 15
01/04/05 10
Total Week 65
You help would be very much appreciated. Sorry to be a bit dense. Also if
you could provide something I could just copy and paste that would be even
better. Thanks in advance

 

[Duane Hookom]

Your query could be a totals query that groups by agent and date completed
while counting completed. Use this query for your report and set the sorting
and grouping to Agent then date completed. You can also group by week of
date completed if necessary and add group headers and/or footer for titles
and aggregates (sums).