Question How to transfer a field old value to another field

[reidi_lexi]

Hi there,

I have two fields, one is for the recent data/information a record has while the other has to comprise the first field history information...how can I do this? Any idea?

Thanks!

 

[Galaxiom]

When the history is required the field is generally held in a one to many related table as multiple records along with a date/time field for when it was entered. The current value is the record with Max([datefield]). This allows a complete history.

 

[reidi_lexi]

I actually need to this in one table only so for example:

First Field data
aaaa1111

Once, I have deleted it and changed it to bbb1111, the second field would have aaaa1111 value. Once I changed the first field value again to cccc1111, the second field would have aaaa1111 and bbb1111 so the recent values for the fields would be:

First Field
cccc1111

Second Field
aaaa1111
bbb1111

I hope I make it clear.

 

[Galaxiom]

I actually need to this in one table only

Why?

Access is a Relational database. What I described is standard practice and there are many good reasons to do it that way.

 

[GPGeorge]

I actually need to this in one table only so for example:

First Field data
aaaa1111

Once, I have deleted it and changed it to bbb1111, the second field would have aaaa1111 value. Once I changed the first field value again to cccc1111, the second field would have aaaa1111 and bbb1111 so the recent values for the fields would be:

First Field
cccc1111

Second Field
aaaa1111
bbb1111

I hope I make it clear.

This makes no sense. You are approaching this as if you had a spreadsheet in front of you. You do not. You have a relational database (that's what Access is, a relational database).

Glaxiom has given you the right approach. Create a history table to store the previous values and dates.