Ms access updating and viewing record
Since you cannot index calculated fields anyway, there is no performance benefit to be gained from using them.You are violating fundamental rules of data normalization for no good purpose.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.
How do you get Access to store the result of a calculation?If you change the Expression after data has been entered into the table, the existing results may not be updated correctly (through new records are edits are updated), so you cannot rely on the results.A compact/repair does not recalculate, so there is no obvious way to repair the bad results.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.If you are concerned about how a user could enter the calculated total with this arrangement, see Enter text in calculated controls.Access 2010 allows you to put a calculated field into a table, like this: Just choose Calculated in the data type, and Expression appears below it. Access will then calculate it each time you enter your record.This may seem simple, but it creates more problems that it solves.You will quickly find that the expressions are limited.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.There are circumstances where storing a calculated result makes sense - typically where you need the flexibility to store a different value sometimes.