query or table auto populate

[merlin666]

Is there a way to have a table or query essentially copy data from one field into a different field on the next record each time a new record is added.

Table1
Record1 | field1 | field 2
Record2 | field1 | "Copy of Record1 Field1"
Record3 | field1 | "Copy of Record2 Field1"

Also if possible can this be done so that if Record2 Field1 value is XYZ then it copies from Record 1 Field1 not Record2 Field1. The XYZ value would always be a static value.

Thanks for any help

 

[Uncle Gizmo]

I'd be inclined to do this in a spreadsheet and then import it into access.

 

[boblarson]

The XYZ value would always be a static value.

This may be a stupid question, but why are storing data over and over again that is the same for every record? Or is there something missing from your description?