Count of entries

[Guest]

Two employees sanitize machines on a roughly 2:1 split
They have requested a tally for each person so the work can be divided up a
bit better.
To enable this I have the following in a text box:
=Count([qryJointWater]![fldSanitising]) Like "1"
Where 'fldSanitising' holds 1 for person A, 2 for person B and 3 for
unallocated.

The result is 0 whereas it should be in the hundreds.
Where am I going wrong?

tia.

 

[kingston via AccessMonster.com]

I think you should do this in a totals query (Group by person, Count of
person), but if you really want to do this in a text box calculation, try:
=DCount("*","[qryJointWater]","[fldSanitising]=1")

Two employees sanitize machines on a roughly 2:1 split
They have requested a tally for each person so the work can be divided up a
bit better.
To enable this I have the following in a text box:
=Count([qryJointWater]![fldSanitising]) Like "1"
Where 'fldSanitising' holds 1 for person A, 2 for person B and 3 for
unallocated.

The result is 0 whereas it should be in the hundreds.
Where am I going wrong?

tia.