Copy many records and udpate specific fields

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

Guest

I would like to be able to select specific records based on one field value
and copy all of those records to new records. I would like the AutoNumber
primary key to update. Also, I would like to update one other field.

For example, if my existing query looks like:
AN1 F1V1 F2V1 F3V1 F4V1
AN2 F1V2 F2V2 F3V3 F4V1
I would like to append and update to:
AN1 F1V1 F2V1 F3V1 F4V1
AN2 F1V2 F2V2 F3V3 F4V1
AN3 F1V1 F2V1 F3V1 F4V2
AN4 F1V2 F2V2 F3V3 F4V2

1. I believe I first need a query to select the F3 values that I want to
copy.
2. Then, I need to copy those records.
3. Then I need to update the F4 values.

I can do this manually in the query design and tables but how do I make this
user friendly?

Thanks in advance for any help.
VG
 
Back
Top