Update Queries and Key Violations

[ebrooks54]

Maybe I'm just not seeing clearly, but it seems like it should be simple enough to do:

Two tables:
History Table: ProdCode / Description / TotSales
Transact Table: ProdCode / QtySold

I want to do an update query that increments TotSales in the History Table, or if the ProdCode does not exist to add the record.

If the ProdCode already exists in the History table, I get a "Key Violation" error.

What am I missing?

 

[lupins46]

On query cannot do both update and add record actions.
You need an Update query where there is a match between the two tables.
And a separate Insert query where there is no match between the two tables.