How do I store calculated values from form to table without making a query? In few of my fields I have expressions and every time I save it only the data I filled in will be saved in the table but not the calculated ones. Thank YOu.
How do I store calculated values from form to table without making a query? In few of my fields I have expressions and every time I save it only the data I filled in will be saved in the table but not the calculated ones. Thank YOu.
In general, calculated values are not stored in tables, but calculated on the fly when they are needed in forms, reports or queries.
I had 6 columns, one for each round and another column for the total. The form was based on a datasheet and I coded the form to do the calculation upon the Focus event.
This way it automatically enters the value into the field and saves the values calculated into the table.