Query to Extract new Employee and old employee

**dollygg** · 08-12-2019, 11:56 AM

I have two access tables. One is Table A, containing three employees. they are 001, 002 and 003. Table B contains 4 employees. They are 001 and 004 and 005. I need the new employee report, which I am expecting to see employee 004 and 005. I also need the old employee report in which I expect t see employee 002 and 003.

**JoeM** · 08-12-2019, 12:39 PM

Note that Access has a built-in "Unmatched Query Wizard" which can help you to do this easily.

Query to Extract new Employee and old employee

Thread Tools

Query to Extract new Employee and old employee

Similar Threads

View report for specific employee by clicking a employee name in combobox

Viewing a subreport by employee, as a part of cumulative report for that employee

how do i place an employee picture from employee table into the asset table's form

If Employee Selected Do Not Allow Employee to be Shown in Drop Down Again

Filtering employee id with query on a form

Posting Permissions