Update one field from another field within the same table (1 Viewer)

[saledo2000]

Hi everyone,
I have problem to update PuchaseDate with the date in the field PurchaseOrderDate. Both fields are in the same table tblPurchase. Image is attached. Could you please help with this issue. Thank you.

 

[plog]

Please explain the system more. How is PurchaseOrderDate getting into the table, and why isn't PurchaseDate getting in the same way at the same time? Why do you have 2 fields if the values are going to be the same value and will they remain the same value? How often do you expect to have to use this update process?

 

[Guus2005]

when you do that you are storing the information twice. you dont want to do that.
If you must, use a calculated field. then the information is shown the way you like while it is stored only once.
You have to check if Access allows creating calculated fields.

Another option is to create a query and use it like a table. In this query create the field you want to show.

HTH