Copy record

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splt a length record into multiple lengths 4
How to count consecutive records base on 2 groupings 0
create append query resulting in multiple new records 4
Querry to get unique records from 3
combo box 1
calculation based on previous record 0
Append Query Issue 0
Help: Need 1 criteria to find many parts of 1 field 3

Back
Top