I have two related tables in my Access database Student and Advisor, related in advisor_id field.
The problem is that when I try to print a student report , all field are empty if the advisor_id is null.
Printable View
I have two related tables in my Access database Student and Advisor, related in advisor_id field.
The problem is that when I try to print a student report , all field are empty if the advisor_id is null.
you need to check you links in your report. Most likely you have an inner join set up and it needs to be an outer join if you want records from one table when the joined field is null in the other table.
It worked thanks!
you bet