Forum Discussion
Update a field in a table from a button on a form
I have a equipment calibration database I am working on. One table holds each tool I calibrate, let’s cal this my EquipmentTBL. The other table holds my calibration data from each calibration, we will...
Typically, we do NOT store calculated values in tables. Your field "Next Calibration Date" is a calculated field and should not be used. The better approach--the one followed by professional Access relational database application developers--is to perform calculations like this ONLY in queries for DISPLAY on forms or reports.
So, my response would be to remove that field from the table rather than try to add additional complexity to the application with this step.
I should be a bit more accurate. You can calculate the "Next Calibration Date" in a query, but it can also be calculated in a control on a form or in a report.
