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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SendObject Macro 10
Using Query Field to name SendObject file 3
Macro conditions to open a query 2
SendObject Macro to multiple Recipients 1
Prompting for Criteria already defined in Report/Query. 1
A Report, based on query, called from macro is prompting for param 1
DateSerial in Macro Condition 4
Use Macro to Filter records in Subform on open 0

Top