[bob8000]

Hi everybody

I would like to know how you define a query to return ONLY something
and not either, or.

Example

Company 1 supplies BOTH catagories (Domestic and Commercial)
Company 2 supplies ONLY Domestic

if you had two companies who supplied equipment and two catagories
(Domestic and Commercial). If these two companies supplied Commercial
equipment and one of these two ONLY supplied Domestic. How would you go
about displaying the one supplier that ONLY supplied both catagories.

But you don't know which company before you do the query so you would
not be able to have the company name as a criteria - if you see what I
mean

In this case the answer would be Company 1.

But how do you get Access to do this.

Any help would be great.

Thanks

BOB8000