Condition for No Data

  • Thread starter Thread starter Jani
  • Start date Start date
J

Jani

I have a macro which appends a temp table to a SQL table and then deletes
data in the temp table but only if the Close field is a 'Y.' Sometimes there
is no 'Y' in the Close field in the temp table. How do I write a condition so
that a message pops up stating that no records were appended? Thanks! Jani
 
Jani,

Try like this for your Condition for a MsgBox action:

DCount("*","NameOfTempTable","[Close]='Y'")=0
 
Back
Top