Access query help

[karina]

here is my table:
Company Address Deleted
AAA USA NO
AAA USA Yes
BBB Canada NO

I would like to select only those companies that have YES in "deleted" field (if they are duplicated as in AAA case). But if there is only one record for the comapny (as in BBB), I also wanna select it, even though "deleted" = "NO".

So the result of the query will give me this:
AAA USA Yes
BBB Canada NO

Can anyone please help me. I'm a little confused.
Thanx.

 

[Parra]

Are you just trying to get unique Companies from your table?

If you are. In the query design view, choose only company and address and click on the sum icon in the tool bar. It looks like a big letter E. Then run the query.

The sum feature will group, fields that are similar. If you want to know if it has a yes or no, that is another step, but I want to know if this helps first.

Parra