Query help

[Cloonalt]

I have a table with multiple instances of Field 1. Field 2 may be 0 or 1, for instance:

Field 1 Field2
ABC Company 1
ABC Company 1
ABC Company 0
DEF Company 0
DEF Company 0
DEF Company 0

Can I write a query to get only Companies where there are all 0s?

Any help appreciated.

Thanks.

 

[gmmastros]

Denis, I think you missed one.

Having Count(1) = sum(ascii(Field2) % 78)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom