S
ScotStuart
Hi
I have a table which details the number of fax orders I receive daily. The
table holds all faxes received this year so far. My dilema is .. I should
like to have a query that can be used to generate a report that shows how
many faxes each individual agent has processed per day in a week. The fields
are titled DATECOMPLETED and AGENT NAME. I am flummoxed by the filter and
expressions to use. If at all possible I should like the report to look
something like below if at all possible.. ( I am using ACCESS 2003):
Agent Name
Date completed total
28/03/05 10
29/03/05 10
30/03/05 10
31/03/05 15
01/04/05 15 Total 60
Agent Name
Date completed total
28/03/05 10
29/03/05 10
30/03/05 10
31/03/05 15
01/04/05 15 Total 60
Total for week 120
Any help, preferably that I can copy and paste would be very much appreciated.
Thanks in advance.
I have a table which details the number of fax orders I receive daily. The
table holds all faxes received this year so far. My dilema is .. I should
like to have a query that can be used to generate a report that shows how
many faxes each individual agent has processed per day in a week. The fields
are titled DATECOMPLETED and AGENT NAME. I am flummoxed by the filter and
expressions to use. If at all possible I should like the report to look
something like below if at all possible.. ( I am using ACCESS 2003):
Agent Name
Date completed total
28/03/05 10
29/03/05 10
30/03/05 10
31/03/05 15
01/04/05 15 Total 60
Agent Name
Date completed total
28/03/05 10
29/03/05 10
30/03/05 10
31/03/05 15
01/04/05 15 Total 60
Total for week 120
Any help, preferably that I can copy and paste would be very much appreciated.
Thanks in advance.