Unanswered: get aging from a open date to the current date
I have a database where I have a field [open date] and a field [close date], I have another field [aging]. Im using a form to capture the information, I need to get the following: when i enter [open date] I need to calculate aging based on the current date Vs the open date, that's mean 0, in the next day aging must be 1, and in that way 2 for the next day, 3 for the next..... but when I enter data on close date, I need to have aging always calculated betwen close date and open date.
Do not store a computed value in your database if you can avoid it. Compute the Aging data on the fly instead. If you really want to keep this data stored in a table, run an UPDATE query on a regular basis (e.g. each time the database is open) to re-compute the values.
Thank you for your comments, I just did that, I'm calculating the value every time I update the data. Running a update query. Thank you for your advices, actually now I'm remembering somethig I read about calculated fields where it recomends to do not store this kind of data, instead calculate to show on reports.