Force values (or null) in qry

[halnurse]

I have a table that holds all of the information for all of the materials that a project will need. As these materials are received another table is filled out with how much of the material was received, what the packing slip number was... The second table has a drop down of all of the material from the first table and then the received quantity is just a number field. When I run a qry for the two fields, only the material that has been selected in the second table shows as well as the value entered for received quantity. Is there a way to show all of the "material" from table 1 and just have a null value for the received quantity from the table 2 in the query?



For a little more background: I am trying to have a calculated field later in the qry that takes the quantity ordered and subtracts the quantity received to give a value for "Back Order". With a null value I think I am able to write a IsNull Function to make the value a 0 in a separate column.

Thank you

[isladogs]

Use an OUTER (or LEFT) JOIN to get all records from table 1 together with matching records from table 2