Query to return records with both empty and populated field

[JSimoncelli]

I am trying to create a query that returns records whether a field has data or not…
There are three fields in question, SSN, DOB (this is a date field), POB (this is a foreign key representing a state in the query shows the actual state). Now unless the criterion is different then I just need the answer for one I can reproduce.
I would like to do this in the criteria box in the query.
The query pulls from one table, some of the employees in this table have the three fields populated some don’t. I would like the query to return all employees…
See Query Attached

John

 

[plog]

You need to create a LEFT JOIN (http://www.w3schools.com/sql/sql_join_left.asp) from tblEmployee to tblPOB. Right click the link between the two tables and then select the option that gives you all results from tblEmployee.

 

[JSimoncelli]

dohh.... Thanks for the easy button, I guess if one looks at it to long the simple answer can elude you.....

:banghead:

All better now... Thanks...

John