Either run UPDATE action SQL or in form BeforeUpdate event, set field to calculated value.
VIP
Windows 10 
Access 2010 32bit
Either run UPDATE action SQL or in form BeforeUpdate event, set field to calculated value.
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.
Advanced Beginner
Windows 10 Office 365
"Either run UPDATE action SQL or in form BeforeUpdate event, set field to calculated value."
Thats the method I was thinking about. thank you. that should work
Very Inert Person
Windows 10 Access 2016
I said as much in post 9Thats the method I was thinking about. thank you. that should work
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Calcualte a total based on other groups in the same report footer
How to use option button to store value into table
Posting Permissions
Reply With Quote