We have data in calculated fields. We would like to change the calculated values to fixed values for archival purposes. Can this be done in Access.
We have data in calculated fields. We would like to change the calculated values to fixed values for archival purposes. Can this be done in Access.
No. If you want to save calculated value that will require code. Usual approach is macro or VBA behind form that saves value to field during data entry. What exactly is the calculation? Why would the result change?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.