View Full Version : Insert and update in same sql statement


tinfoil2004
02-20-2008, 12:30 PM
Is it possible to have an insert and update in the same sql statement using MS Access 2002? I could split it into seperate statements but for code purity I would like to have it in one :cool:

pbaldy
02-20-2008, 12:32 PM
Maybe:

http://support.microsoft.com/kb/208870/en-us

tinfoil2004
02-20-2008, 12:38 PM
Thank you for the quick reply. I will give that a go