I'm dealing with existing records that contain missing data in some fields. For example, i run a query on a clients name and i want to include all the project #'s associated with his name and the zip code to each project #. the problem is if the older records dont contain a zip code then the query doesn't display those paticular records. How can i can i return null values in these fields so i can display all the project #'s regardless if there's a zip code associated with them?

In my Query i have a Client table, a Work Order table, & Zip Code table. The Client & Zip code table each have Primary ID's that are included as fields in my Work Order table. so there is a relationship to each table.

any thoughts on how to solve this issue???

NEVERMIND!!! i solved my own problem for the moment and it appears to be giving me the results i'm after :)

If you post a question and then find the answer on your own, you should (out of curtesy) post some of your solution.

-Phil-