Copy record

[Guest]

I want to copy a record from a table and create a new record in the same
table but with the amount field changed e.g if amount is 1.00 it should read
in the new record as -1.00 . Append querry craetes a record 'as is'. Do I
need to create an append as well as update querry?

 

[Guest]

In design view for your append query pull down the individual fields. For
that one field edit from YourField to look like X: [YourField] * -1

Set your criteria and run.