Printing report with no records

P

Phil Ferguson

Included in a macro is a report print but I would like access to ignore
printing the report if there are no records in the report. Is there a way to
do this in a macro?
 
C

Chris Reveille

You need to know how to set up a condition that counts the
number of records in your report criteria? Try this as your
condition statement of your print report action:

DCount("[Fieldname]", "ReportQueryName")>0

Chris
 
P

Phil Ferguson

Perfect!!!! Thankyou

Chris Reveille said:
You need to know how to set up a condition that counts the
number of records in your report criteria? Try this as your
condition statement of your print report action:

DCount("[Fieldname]", "ReportQueryName")>0

Chris
-----Original Message-----
Included in a macro is a report print but I would like access to ignore
printing the report if there are no records in the report. Is there a way to
do this in a macro?
.
Click to expand...
Click to expand...
 
Top