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