URGENT

[NewBe2]

I have 2 tables: CUSTOMER and SLSREP with fields (amongst others)
CUSTOMER (Cur_Balance, Slsrep_Number ..)
SLSREP (Slsrep_Number ...)
How do I find the total Cur_Balance for the salesmen who have more than 4 (four) customers ???
All the mentioned fields have numeric data types.

Thanx in advance !!!

 

[tlbroadbent]

Enter the following into the SQL view of the Query Designer.

Select Slsrep_Number, Sum(Cur_Balance) As Tot_Balance
From CUSTOMER
Where Slsrep_Number In
(Select Slsrep_Number
From CUSTOMER
Group By Slsrep_Number
Having Count(CustID)>4)
Group By Slsrep_Number;
Terry

http://members.home.net/tlbroadbent/prog.htm

_____________________________________
Man's mind stretched to a new idea never goes back to its original dimensions. - Oliver Wendell Holmes

 

[NewBe2]

Thanks a lot for the quick responce !!!
It works perfectly.