Query Help - is there an ONLY function

[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

 

[Doug Robbins - Word MVP]

You would use a query in Access. It would be necessary to know exactly what
is entered in the field to be able to advise the criteria to be applied.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP