Access 2003 - A count Query/Report
Posted on 2007-11-21
I have got a Contact/Sales DB, with tables, forms, queries and reports already configured and setup.
I would like to set up either a query, which I can in return use in reports, or a report directly which will count how many sales were made by a sales agent.
The fields I thought that could be used are the following:
Sub Franchise(Sub Franchise Table)
Sales Agent(Sales Agent Table)
GR number (reference number to the contact)(Contacts Table)
First Name(Contacts Table)
Last Name(Contacts Table)
Sale Date(Contacts Table)
What I would firstly like to know, what am I going to use here, a query or a can one use the report function straight to get how many sales one Sales Agent made.
For example. John Smith made 5 sales for the month of October. I would like to see the total sales counted for me in a query or report that just shows the total figure.
Any help would be greatly appreciated.