Returning Null Values in a query
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???