I have a table which I need to move certain currency figures from field1 to field2. Neither field contains any null values. I've created an update query to accomplish it.

My problem is when I run the query, I received the following window.

"Microsoft Access can't update all the records in the update query. Microsoft Access didn't update 2868 fields due to a type conversion failure."

I've checked my data types in the table. Both fields are currency data types.

Am I missing something?

Does anyone have any ideas???

Try posting your SQL statement in a reply on this thread, your SQL might be trying to do something other than what you intend.

Trying to transfer prices from Field1 to Field2 in Table1.

Before running the query, Field1 has the prices and Field2 prices are all $0.00.

After running the query, Field1 and Field2 prices are all $0.00.

Here's the SQL procedure used:
UPDATE Table1 SET Table1.Field2 = [Field1]
WHERE (((Table1.Field2)=0))

What's going on?

It should work as long as the value of field2 really is 0. Make a copy of your table and try running the query without the where clause, if all of the values in field2 are 0, then the where clause isn't doing anything anyway.

Check it over real well to make sure you don't have a typo that criss-crosses your fields. Try repairing the db and running it again, keep playing around with it, something isn't making sense.