Query doesn't show null values

[Newbie456]

I am trying to create a query that takes data from several tables. I have a series of combo boxes on my form that populate based on selections from other combo boxes. Some of these remain empty, if the field doesn't pertain to a previous selection.

When I try and run the query, it doesn't display records that have these blank values. How do I manage to get it to diplay these records?

 

[PHV]

Have a look at OUTER joins (LEFT or RIGHT).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Newbie456]

Yes, thank you for forcing me to figure out what that means. Simple solution. Thanks!