Saving Values

[Chris]

Hey,

I have set up calculations in some of the text boxes in my form
1. % Uptake
2. No Meals
3. Possible No Meals

but the answers dont seem to save in to my table how do i get them to
save??

I also have a combo box with 3 columns
1. School
2. No. Pupils
3. Cost Center

but only the School saves into my table... how cant i get No. Pupils
and Cost Center to save into my tables..??

 

[Arvin Meyer [MVP]]

Recalculation of the result is much faster than disk access, so it is
inefficient to save the results of calculations. Even spreadsheets
recalculate and do not save the data in the formula cells. Besides that,
doing so in a database is a violation of normalization rules and is
discouraged everywhere except in cases where a history of the result must be
kept. Even there, I prefer to save all the elements of the calculation,
rather than the calculation itself.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Chris]

The results from the calcualtions must be kept as they are required
for reports...!!!

 

[Rick B]

You can calculate them in your report the exact same way you calculate them
in your form. Just add an unbound text box and enter your formula.