Update else Insert

[RC-]

I need to write a query that will Update data if it exists or Insert if it
does not exist.

I have been trying to modify this query, but I don't really know the syntax:

IF EXISTS (SELECT * FROM tblDefaults WHERE defPhone = 9155883738)
UPDATE tblDefaults
SET defCostCode = '1-57000-5', defProjectID = 'C06115'
WHERE defPhone=2015551212;

Can anyone tell me how to Update else Insert the data?

TIA
RC-

 

[Brendan Reynolds]

I don't believe this can be done in a single JET query. I believe you will
need to use code to detect whether the record exists and execute either an
update or insert query accordingly.

 

[RC-]

OK, thanks for the quick reply!!

RC-

I don't believe this can be done in a single JET query. I believe you will
need to use code to detect whether the record exists and execute either an
update or insert query accordingly.