May 24th, 2004, 06:02 PM
|
|
Query Quandries
Could you post the SQL for your query.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
"Frank" wrote in message
...
i have a table, tblgeneral, that contains order
information on customers, referenced by tblcustomer, what
i am attempting to do is show how many unique customers -
and the total repair cost for a date range per salesman.
for example; salesman 1 had a total repair cost of 1500.00
for the month of january 04 from 5 different customers.
what i am currently getting is; salesman 1 had a total of
1500.00 from 20 customers (it is counting the total number
of customers - not the unique number)
Please help - i am getting so confused.
Frank
|