This seems simple enough...but I don't know how to do it!
I have a query that selects records based on date criteria from a table called Bookings. The returned data can contain more than one record with the same Employee number (in the Employee Number field).
I want a query or form which lists all of the records in a different table (Employees (primary key Employee Number)) excluding those records with Employee numbers that are the same as those retrieved by the aforementioned query.
The Employee field in the two tables is linked in a One to Many relationship (Employees Table - One, Bookings - Many).
Any ideas?? Help appreciated!
I have a query that selects records based on date criteria from a table called Bookings. The returned data can contain more than one record with the same Employee number (in the Employee Number field).
I want a query or form which lists all of the records in a different table (Employees (primary key Employee Number)) excluding those records with Employee numbers that are the same as those retrieved by the aforementioned query.
The Employee field in the two tables is linked in a One to Many relationship (Employees Table - One, Bookings - Many).
Any ideas?? Help appreciated!