calculated fields are not saved in the tables, is there a way to break that rule.

[gino]

my subject basically explains it. it may sound wierd but yes i need to build this database that way. many people can't calculate for themselves and so i need a user friendly database. i only need a total and that total i wish to save in a table. with this i can save alot of memory for unnecessary fields. if anyone knows how to do this. please share your knowledge. thank you.

 

[Axis]

Rules are made to be broken, although you should always be sure that you really want be an outlaw. In your case the consequences probably aren't too bad. Here's an example.

Field1
Field2
TotalField

Field2.AfterUpdate
Me!TotalField = Me!Field1 + Me!Field2

Assumes these are all numeric data. This is a very simple example, but may be you can figure it our from here.