How do I display or call up Null records of a matching field in a.

[Guest]

I created a query which have tables of matching fields and wanted to call up
the null values as well as the other records. My report is linked to the
query and I need to be able to print those null records. what should I do?

 

[Rick B]

You want to print all records from your main table (regardless of if there
is amatching record in the secondary table)?

In your query design view, you should have the two tables displayed with a
line connecting them (joining them). Right click on this line and change
the "join properties". One of the options says to "display all records from
table1 even if..."


Rick B

I created a query which have tables of matching fields and wanted to call up
the null values as well as the other records. My report is linked to the
query and I need to be able to print those null records. what should I

do?