I did some research on the Net and in response to my previous post I'm
thinking the problem is a result of needing to set an Outer Join
instead of a inner... However, how do you specify an Outer Join in the
Microsoft Access Query Creator? I haven't done SQL in years so it's
plenty rusty and would rather not go that route.

adel.ather (AT) sympatico (DOT) ca (ninjaking) wrote in message news:<66700bb5.0404201120.71317321 (AT) posting (DOT) google.com>...
Hello,

Go into design view of your query, which according to your question, should
have at least two sources your querying form and are linked together.

Double click on the link, or right click on it, and a popup dialog box
should appear. Change the selection from a 1 to a 2, or what will fit
your needs. This should change the link from an Inner Join to an Outer Join.

Or what SQL uses, a Left join to a Right join.

Regards,

Ray