Null values messing up the end result

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top