Hi, Does access have a syntax for an upsert query. I mean insert record, if key already exists than do an update of the fields for that record?