hi, I'm looking on the net a query that allows for the inserting if there are no duplicates and update if I find a duplicate, I find this syntax query
INSERT INTO table (a, b, c) VALUES (1, 20, 68)
ON DUPLICATE KEY UPDATE a=a+1
in this links SQL ON DUPLICATE KEY UPDATE
but he says it is a MySQL functionality.
Does there-an equivalent of this in Access?
Nishant MittalPosted Jan 4, 2016, 1:24 AM