I am setting up a photocopying query based on a table with the following criteria.
Date = the date the record is entered into the database.
Center = the center that will pay for the copying.
Copies = the number of copies that were printed for each center.
In the query I can group by center and sum by copies. It gives me the total number of copies made for each center since the database was started. Perfect if I need a total of copies made since the beginning of time. However I would like to narrow the scope down to month to date totals. As soon as I add the date column to the query it no longer gives summary totals, but each record ever entered.
How can I sum by date, group by center and sum by copies?
Cheers
Kirk
Date = the date the record is entered into the database.
Center = the center that will pay for the copying.
Copies = the number of copies that were printed for each center.
In the query I can group by center and sum by copies. It gives me the total number of copies made for each center since the database was started. Perfect if I need a total of copies made since the beginning of time. However I would like to narrow the scope down to month to date totals. As soon as I add the date column to the query it no longer gives summary totals, but each record ever entered.
How can I sum by date, group by center and sum by copies?
Cheers
Kirk