Check Fields Macro

  • Thread starter Thread starter esi
  • Start date Start date
E

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?
 
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.
 
Back
Top