Using a macro to print 2 reports

K

kdzobel

I have a table that prints a report when data is present. I want to be able
to check the table if no data print another report. Can you or how do you
setup a macro to do this. Thanks
 
S

Steve Schapel

Kdzobel,

In the Condition column of the macro design, put the equivalent of this...
DCount("*","YourTable")=0
 

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

Weekly Report 2
How to automate update on weekly reports spreadsheet 0
How to have two tables on same line? 1
Page numbering with Merged Document and IF statements 1
Print order of TriFold - Publisher 365 0
Printing Outline view - formatting lost 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
VBA word change keys 0

Top