Marco Condition based off a Query

[bigbox486]

Hello,

I have a macro that opens a report and then prints that report (simple 2 line macro). I have then created a query that returns values only if a date field = today's date. I would like to make this query a condition of the macro so that is the query returns any values the report will print, but if it doesn't have any values (NULL) then it will bypass this line in the macro.

Any advice on how to go about this?

Thanks!


Bryan

[pbaldy]

You can use DCount(). You could also use the no data event of the report.