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
 

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
Macro conditions to open a query 2
Using Query Field to name SendObject file 3
DateSerial in Macro Condition 4
A Report, based on query, called from macro is prompting for param 1
Cancel Macro If Table is empty. 5
Prompting for Criteria already defined in Report/Query. 1
Repeat macro until record count of query = 0 0

Back
Top