Conditional Macros

[Chris]

I know you can run a macro depending on whether a condition is met in a form
or not....but how about a table or query ?

I send out reports to a huge group of people on a monthly basis. Sometimes
their reports contain no data and shouldn't be sent...is there a way to not
send the report if it's blank ?

Thanks for reading

 

[Ken Snell [MVP]]

Sure... use the DCount function to test if there are records .. use this as
the Condition expression.

 

[Chris]

perfect...thanks very much Ken !!!!

Sure... use the DCount function to test if there are records .. use this as
the Condition expression.