Grouping query problem

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

i have 3 tables; clients, salesman, general - salesman
relates to clients, clients to general. based on date
parameters (beginning and date) from recd-date in general
table i need to find out how many clients each salesman
has dealt with.
Thanks in advance
Frank
 
Hi,



SELECT salesman, COUNT(*)
FROM (SELECT DISTINCT salesman, ClientID
FROM sales
WHERE recdDate BETWEEN beginning AND ending )
GROUP BY salesman



Hoping it may help,
Vanderghast, Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with Update query 4
Max totals 1
duplicate query 1
Query with Zip Code Mis-match (5 digit vs 9 digit) 2
help with a query 3
Grouped top values help 1
Query Quandries 2
Summing values in table 3

Back
Top