So i made a query and I need to find the two higest balances of two customer. How do I do that? And in another query I need to find all products with a cost less than $5.00, I enter in the cost <5, and all the products come back? 
Need help asap in a query
- Thread starter Juliekay
- Start date
SteveSchapel
Registered User.
- Local time
- Today, 21:05
- Joined
- Apr 29, 2010
- Messages
- 242
Juliekay,
I think we would really need to know some more details of your table, and the data in it, and the meaning of "two highest balances", before anyone could give a good answer to the first question. Can you give some specific examples?
Entering <5 in the Criteria of the Cost field in your query should be the correct way to achieve your second requirement. Can you copy/paaste the SQL view of your query into your reply here?
I think we would really need to know some more details of your table, and the data in it, and the meaning of "two highest balances", before anyone could give a good answer to the first question. Can you give some specific examples?
Entering <5 in the Criteria of the Cost field in your query should be the correct way to achieve your second requirement. Can you copy/paaste the SQL view of your query into your reply here?
Similar threads
