field en record problem

[Petrus Van den Cruyce]

i have a database in with i 'd like to do the following: from record 1
the value of field 3 should be copied into record 2 field 3, from record
3 the value of field 3 to record 4 feild 3, etc..
How do i manage this in access or excel?

 

[Joseph Meehan]

i have a database in with i 'd like to do the following: from record 1
the value of field 3 should be copied into record 2 field 3, from
record 3 the value of field 3 to record 4 feild 3, etc..
How do i manage this in access or excel?

Are the records already there or are you adding records?

It the records are already there, you can use an update query.

If you are adding new records pressing control and the ' sing together
copies the prior records data into the field that has the focus.