November 27, 200619 yr I have a database with a "DaysOld" field It is a calculated field based on the days from record creation to today. I want to use it in a list report. Currently, it only calculates when I access the specific record. Is there a way to globally recalculate this field so that on any given day, the report is correct.
November 28, 200619 yr .. Make DaysOld an unstored calculation result number: Get(CurrentDate) - CreationDateField
Create an account or sign in to comment