Choosing between update and insert

[gaju_3112]

I am running a query which uppends the record to one table from another table. My requirement is that, it should check one field of the destination table table before inserting the record. If that field matches, it should run Update query or else it should run Insert Query. How Can I do that?

Please Reply!

 

[Rabbie]

Hi

You would need to use VBA to do this. Test the condition and run the relevant query depending on the result of the test.