Print reports only where records contain data.

[dkharris]

I have a database that contains information on students the subjects they
take and grades are recorded at different times during the year. The
database contains tables named tblOption1, tblOption2, tblOption3 and
tblOption4 these tables store information about the students options they
have selected however some of these are left blank. I have created a report
that shows and prints information from all 4 tables even if there is no data
in them. I would like to know if it is possible how to print only those
records on the report with information in. Example if a student takes 4
options the report shows the 4 options he/she takes if another student takes
2 options the report shows the 2 options he/she takes.

All help greatly appreciated.

 

[Duane Hookom]

IMHO have 4 separate tables is a mistake. I wouldn't go much further until
this was corrected. Depending on your table structures, you might be able to
create a union query based on the 4 tables and use the union query as your
report's recordsource.