Update table Statistics

asuni

New member
Local time
Yesterday, 20:47
Joined
Apr 29, 2008
Messages
9
Hi all,
I am new to Access. I am using Access 2003. How to do Update table Statistics or Update Statistics. Any help please
Thanks
 
The only thing you have to worry about is indexes. The rest you cant do anything about. If you can, then you are not using Access 2003!
 
First, it is not a good idea to store calculated data in a table. The correct place for doing math functions is in a query. The reason is simple. If you keep the calculated data in a table, you have to re-do the math to update each of the calculated fields every time you make a change.
The correct method would be to create a query that displays the calculated stats, then use that query for your forms or reports.
You don't have to re-do the maths each time, it's already done when you open the query. The only updating required is for the fields in your table that hold the base data your stats are based on.
 

Users who are viewing this thread

Back
Top Bottom