Check Fields Macro

[esi]

I want to create a macro to check that the field [Counted] has a value of
"Y" for every record before running an append query. How would I do this?

 

[Ken Snell]

A Condition such as this may work for you:

DCount("*", "TableName") = DCount("*", "TableName", "[Counted] = 'Y'")

If the above is true, every record has the value of Y in that field.