Condit Macro: test for query being empty

  • Thread starter Thread starter BtwOSU
  • Start date Start date
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
 
BtwOSU,

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