Records with "null" field "drop thru" query

[John Gilchrist]

I am using attached access query to search product order records.
I use the query grid to design this query, and FormulaCodeID is the link
from "Products" table to the "ProductFormula". Some products do not have a
formula, so the FormulaCodeID field in "null".
If the linking field "FormulaCodeID" is null, the record "drops thur", and
is not included in the query results.

My workaround has been tomake sure that the linking fields have some default
contents.

Is there another way to modify this query grid so that null linking fields
are not dropped?? In other words, I want to allow null values, and I want
to make sure these "null field" records are included in the query output.

I've tried playing with the JOIN properties between linked tables, but this
does not work.

Thanks,
JOhn

 

[Suzette]

You need to edit the link so that it shows ALL of the records from the table
that has all the information and only the ones that match from the table
with the null fields. This is assuming that you get the null fields because
that table does not have a matching record.

 

[John Gilchrist]

thank you for your help - that solved my problem
John