Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to force update of a stored calculation across all records

Status
Not open for further replies.

mcarey

Instructor
Feb 13, 2002
7
US
I have a stored calculation (stored because I need it on the rt side of a relationship). I want the calculation to update once per day across all records....I was thinking of doing it in a startup script. (as the db is opened by multi users each day.)...but I forget how to force a calculation to update once it has been stored. How do you update a stored calculation?

Thanks!

mcarey@cccoe.k12.ca.us
 
One easy way to force the calculation is to view the layout where the calculation is located. This is likely in a related database, write a script that goes to the layout and then back again. All you will see is a screen refresh because this happens so quickly.

I've also heard of using:

Enter Preview mode
Enter browse mode

will force a refresh.

Marty
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top