Running a query with related tables and a null value

[simonsimon]

Hi all,

I am having some problems with a query with related tables. I have one table that has master data for a specific equipment number. A second table is linked to this table detailing the area where it is kept where equipment is selected via a combo box. a third table has detailed notes, linked back to the main table by a the note number.

There are some null vaules in the note number feild of the main table - some have a number, some are left blank. When i run the query with the first two tables all works fine. All records show up including records where there is a blank note. As soon as i add in the third table to the query linking the note number to the actual note any records with a null value in the note dissapear from the query.

It must be something to do with the null value but i can not for the life of me work out to let it accept the null when the third table becomes involved.......

I have uploaded the file and a few screenshots if that helps!

Everyones help much appreciated!!!!

Thanks,
Simon

 

[motleyjew]

Try this out. I took out the notetable join in Query2 to show all those records that you need. I then made Query3 which is using joining query 2 and your notetable query but showing all records that were in query 2.

Gregg

 

[FoFa]

Double click the link in designer, and change the join to match all from main table, and those that match from the notes table.

 

[simonsimon]

Thanks Heaps guys - worked perfectly!

Simon