CCBtx Posted November 27, 2006 Share Posted November 27, 2006 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. Link to comment Share on other sites More sharing options...
Genx Posted November 28, 2006 Share Posted November 28, 2006 .. Make DaysOld an unstored calculation result number: Get(CurrentDate) - CreationDateField Link to comment Share on other sites More sharing options...
CCBtx Posted December 21, 2006 Author Share Posted December 21, 2006 Excellent. Thanks for the reply. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6329 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now