Access 2016 updating between two tables
You are violating fundamental rules of data normalization for no good purpose.
We recommend you use queries for calculated fields, just as in previous versions.
If you find yourself constantly entering whatever today's date is in your Access forms or tables, you are wasting valuable time.
Access can do that for you, and you don't have to be an Access expert to do so!
A compact/repair does not recalculate, so there is no obvious way to repair the bad results.
So, how do you get the calculated field if you do not store it in a table? Any form or report based on this query treats the calculated field like any other, so you can easily sum the results. Well, almost foolproof: It is possible to have your calculated fields misinterpreted.
Alternatively, if the field is time-sensitive as well, you can also use the Now() function in place of the Date() function to store both the date and time information.
Date functions are also useful for controlling what dates are allowed to be entered into a given Date/Time field.
In this article, I describe a few ways you can leverage Microsoft Access date functions in your Access 2007 and Access 2010 databases.
If you have never used Microsoft Access date functions, take a look at this quick Beginner's Guide to Microsoft Access Built-in Date Functions that I recently created and shared on our Office You Tube channel.