By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,641 Members | 2,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,641 IT Pros & Developers. It's quick & easy.

Reports on specified data

P: 5
Hi

I'm working on a database within access the uses 3 database tables. Data from each of these files is required to be printed out automatically.
The problem I have is determining whether the specified data exists in each of the tables, and if it doesn't, then skiping that report. The reports contain an SQL statement that directs the report to print the correct data, but if the correct data is not in one of the tables, then it still prints a blank report.

Has anyone had something similar or does anyone know a simple solution. All help would be gratefully recieved.

Thanks
Oct 20 '06 #1
Share this Question
Share on Google+
2 Replies


100+
P: 143
Check out the On No Data property of the report.
Oct 20 '06 #2

P: 5
Bod
Check out the On No Data property of the report.
Thanks very much for your help, that has resolved it.

Phil
Jan 21 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.