Run Formula once on form
Posted on 2006-03-21
I have a field on a form with the following formula
It basically goes out and counts how many grade 8 associate are in the database. I have to run this report weekly and I store the results "report form" and view. The problem is that if I go back and edit a older report to put comments in or adjust it, it will recalculate this formula to today's value. I would only like this to calculate once, on creation and save. Is there a way to set that on the form. I have tried various ways and I keep getting errors. Any help would be most appreciated.