Like many people I have tables I need to add rows to and/or update rows. Instead of using 2 queries to do both is the MERGE statement available in Access 2010 (query)? When I try to run the code it tells me
"Invalid SQL statement; expected 'DELETE','INSERT','PROCEDURE','SELECT', or "UPDATE'" and when I click OK it hilights the word MERGE.
I thought MERGE was Ansi SQL. I may be wrong. If not allowed is there a work around?