Macro Condition to detect a query with 0 records

R

Robert_L_Ross

What is the Condition I would use to determine if a query has 0 records? And
what would the reverse be...to determine if the query has at least 1 record?
 
S

Steve Schapel

Robert,

Like this...
DCount("*","NameOfYourQuery")=0
DCount("*","NameOfYourQuery")>0
 
Top