Condit Macro: test for query being empty

B

BtwOSU

Does anyone know the syntax, in the conditional column of
a macro, to test for a query yielding no data?

I have a macro that "sendobjects" several queries. If a
particular query yields no data, I would like to not send
the empty query.

I would appreciate any help!

Thanks!

BtwOSU
 
S

Steve Schapel

BtwOSU,

Try this as the Condition for your SendObject action:
DCount("*","YourQuery")>0
 
Top