saledo2000
Registered User.
- Local time
- Today, 22:58
- Joined
- Jan 21, 2013
- Messages
- 94
Update one field from another field within the same table
- Thread starter saledo2000
- Start date
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
AWF VIP
- Local time
- Today, 23:58
- Joined
- Jun 26, 2007
- Messages
- 2,642
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
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
