Data Transfer from one field to another

[Sahara May]

Hi,

I am having a trouble figuring out how would I transfer data from one field to another. My dilemma here is that, I need to replace data in a field and replace it from another field.

That is:

I filtered FieldA to the data I want to replace then I want to replace it by the data in FieldB in the same row.

I have used query to transfer data from FieldB to Field A but all the data was replaced when all I want to replace are the "0" amount in FieldA. So how I'm I gonna do that?
Is there any easy and fast way? I've been doing it manual and it's around 600,000 records so it would take me forever to finish it.

Hope I could get a response.

Thank you.

[recyan]

Is this a one time operation ?
If yes, you could use a Make Table Query, which uses an IIF() for creating the new FieldA.

Thanks