Merge query not working

[jj1]

MERGE UserT AS target
USING SUP/TLupdatedListQuery AS source ON target.Username = source.SUP/TLupdatedListQuery
AND target.Password = source.PERSON T-ID
WHEN NOT MATCHED BY TARGET THEN
INSERT (Field1, PERSON T-ID) VALUES (source.Field1, source.PERSON T-ID)
WHEN NOT MATCHED BY SOURCE THEN
DELETE;

I am using this query and it's not working

What I am trying to do is merge 2 tables
I have Table 1 which has old records of employees their names and ID number
and as employee change in the company so new list comes Table 2 is created I ran a query to pull employee name and ID to merge in table 1
so some employee record remain same however some change so i need to delete few in old table and add new ones

[ranman256]

I dont think MERGE is a command. If you built the query from the query design the only option would be append or union.
Do you want to append the diffent data sets to a single table?

or

UNION:
select * from table where set1
union
select * from table where set2


or

do you mean some of 1 table records combining with fields of another table.
this is a join
or
update query.

[June7]

I don't think MERGE is available in Access. As ranman noted, options are UNION or INSERT. You might want to do a Find Unmatched query to determine what data needs to be in the INSERT. There is a wizard for the Find Unmatched.