Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need help writing a query
It works with no problem !!! Thank you for your help.- NewBe2
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Need help writing a query
I have two tables (again) - CUSTOMER and SLSREP The fields are: CUSTOMER (Cus_Name, Slsr_Number, Curr_Balance ...) SLSREP (Slsr_Number, Slsr_Name ...) The question is: Find the total of the current balances for sales representatives with at least three customers - the sales representative's...- NewBe2
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
URGENT
Thanks a lot for the quick responce !!! It works perfectly.- NewBe2
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
URGENT
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...- NewBe2
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
