Good Afternoon all;
I have two test tables I’m trying to perform an experiment on, test1 & test2.
In both these tables; I have a field called ‘yearis’ which is a text field. What I’d like to do is create an append query that will: Update records in table 2 if it exists or append a record from table 1 if it does not exist. According to the ‘yearis’ field in test1.
Is there a way to do this with a standard append query?
Many Thanks for your help.
Kind Regards
Tor Fey
I have two test tables I’m trying to perform an experiment on, test1 & test2.
In both these tables; I have a field called ‘yearis’ which is a text field. What I’d like to do is create an append query that will: Update records in table 2 if it exists or append a record from table 1 if it does not exist. According to the ‘yearis’ field in test1.
Is there a way to do this with a standard append query?
Many Thanks for your help.
Kind Regards
Tor Fey