Hi, Having a few problems with a query which I am trying to get a count but its counting against the wrong thing if that makes sense.
I am trying to run a query to show how many customer a salesperson has booked in. All the data is being pulled from one table. I am pulling 3 fields, salespersonID, customerID, bookedDate.
As each booking is recorded individually there are many entries for the salespersonID, I want to show how many bookings a salesperson has made. So I want to count the customerID and show that against the salespersonID i.e salespersonID 2 made 76 bookings over a period of time.
At the moment though I have 76 different lines in the query with salespersonID 2 next to them all.
I am using the bookedDate field so I can specify the date range for the whole query.
I have tried a count on the customerID but it just counts how many customerID's were booked on the bookedDate.
Anyhelp would be appreciated thanks.
I am trying to run a query to show how many customer a salesperson has booked in. All the data is being pulled from one table. I am pulling 3 fields, salespersonID, customerID, bookedDate.
As each booking is recorded individually there are many entries for the salespersonID, I want to show how many bookings a salesperson has made. So I want to count the customerID and show that against the salespersonID i.e salespersonID 2 made 76 bookings over a period of time.
At the moment though I have 76 different lines in the query with salespersonID 2 next to them all.
I am using the bookedDate field so I can specify the date range for the whole query.
I have tried a count on the customerID but it just counts how many customerID's were booked on the bookedDate.
Anyhelp would be appreciated thanks.