Multiple count - single table, fixed criteria [RESOLVED]

[Br1an_g]

hi,

i need to look at a number of fields within a table, and count where it equals Zero.

e.g.:

MyTable1
               Field1     Field2     Field3     Field4
Record1       5            0           5           1
Record1       0            0           5           1
Record3       1            5           0           0
Record4       0            1           1           5

so my query should retun:

Field1 2
Field2 2
Field3 1
Field4 1

I had done this previously using Dcount, but its really slow.

Done a search on here, and there are a couple of suggestions, but they dont seem to work for my situation.

any suggestions appreciated

TIA