Printing report with no records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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...
 
Back
Top