You need an UPDATE statement, not an INSERT INTO statement.

volgen :)

Thank you Kevin... I was going to be asking a similar question.

Is there any video with Update statement?

Legacy Tip: Microsoft Access Update Query

Access SQL Seminar Part 2

Masih,

The easiest way to get the SQL for the update you want is to create an update query to exactly what you want. Then switch the query to SQL view.

I learned that from Richard.

I second what Sami said.  Especially if your SQL is your weakest link.  Then you have an idea of the structure.

In standard old SQL the statement can look like:

UPDATE Customers
SET ContactName = 'Alfred Schmidt', City= 'Frankfurt'
WHERE CustomerID = 1;

Multiple Records

UPDATE Customers
SET ContactName='Juan'
WHERE Country='Mexico';

But I'd do the Richard recomendation .... cause Sami said so.