Hello,
I have two tables: tblPositions and tblEmployees.
The field pkPosition# is the unique key in tblPositions.
I use fkPosition# in tblEmployees to join the tables in queries.
Most positions have at least one employee, but some positions are vacant.
Most Employees have an fkPosition#, but some employees don't have a Position# yet. (Not yet assigned by another department.)
When I choose the option "Include ALL records from tblPositions and only those records from tblEmployees where the joined fields are equal", Access appears to only be returning the records that have matches. I have several scenarios where I require ALL the position data plus any employee data that goes with it, including positions that match to no employee data right now.
Any help would be appreciated!
Kay
from frozen Toronto