Printing report with no records

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?
 
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
 
G

Guest

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...
 

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

Macro to automatically print current record on update to a report 5
How to stop reports printing with blank fields 2
Using macro to delete value from a specific field in multiple reco 1
A macro to do the open several reports to print 4
Printing from a macro 1
No data in printed report 2
Automatically printing a report based on a new entry 1
Update a table after printing 2

Top