By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,949 Members | 2,038 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,949 IT Pros & Developers. It's quick & easy.

Help with query

P: n/a
I have a query situation I can't, for the life of me, figure out. Any
help would be greatly appretiated.

I have a table of customers, and a seperate table of orders. An order
consists of (among other things) a Buyer and an End User. A single
customer can be a buyer, end user, both, or neither. Also a single
customer can have many orders with the aforementioned criteria.

I simply want a query that will show all customers who are either a
Buyer OR an End User. And I need to eliminate duplicates due to more
than one order.

Ideally the query would simply show:

CustomerAutoNumber: #
Buyer/EndUser: Yes or No

I can build a query that does what I need, but it consists of two
fields...Buyer and End User. I just put an OR in the query and it works
perfectly. The problem I have is that I literally have 30 other posible
conditions in this query, and if I OR this item, I have to repeat the
other conditions for the OR (in VB).

I think I need a query as I've outlined above, with a single
Buyer/EndUers field that I can import into my main search query to
avoid the OR clause.

Any tips out there? Is my thinking way off base?

Jeff Smeker

Nov 15 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.