Suppress printing of null records.

Wellington32

New member
Local time
Today, 15:21
Joined
May 9, 2012
Messages
4
[FONT=&quot]I have a form with a control list of multiple locations, and a button on the form that prints a separate report for each location.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]The problem is that even if the location has no data to report, it prints anyway. What I want is if there’s no data, then skip to the next location.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]What coding would I use to accomplish this?
[/FONT]
 
If your report has a Select query as its data souce I would suggest you could achive the ommission of a record that has not data to report ,by adding Is Not Null in the Criteria .Only records with data would be selected. Hope this helps.
 
Thanks for the suggestion. The reports' current data source is a table, but I think I'll switch the source to a query and use your idea.
 
You are most welcome. Its gratifying to get feed back whether or not the suggestion is used . If the problem has been solved please mark the thread as such .
 
Last edited:
OOPS having a senior moment, there does not appear to be a solved button
Regards BOB:confused:
 

Users who are viewing this thread

Back
Top Bottom