|
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?
Thanks
Jeff Smeker
| 
