Null values messing up the end result

[Guest]

My main query pulls some student ID fields from a table and uses a few fields
from three queries. The problem is if the student does not have information
in all three of the queries the student's information is not listed with the
remaining fields blank. I need the student's info to be in the main query
regardless if the student has any supportive information. I believe I need
to do something with allowing null values to be ok, but I cannot nail where
to begin.

Thanks Frank

 

[Guest]

You need to change the link between the tables from Inner Join to Right/Left
Join, that will bring all the students regardless if the are records for that
students in other tables
Check this link about "Query Joins - Inner & Outer Joins "

http://www.databasedev.co.uk/query_joins.html

 

[Guest]

Thanks, this is perfect.

You need to change the link between the tables from Inner Join to Right/Left
Join, that will bring all the students regardless if the are records for that
students in other tables
Check this link about "Query Joins - Inner & Outer Joins "

http://www.databasedev.co.uk/query_joins.html