populate calculated text box from main form

[Revned]

hi,

is there anyway to populate calculated fields like my text boxes in my main
form
to a table

i just want to ask this question because i have text boxes with formula on it
can i tell access to populate it in a table...can you give idea how or any
sample db or link to read from

i appreciate your time and kind help

thanks

 

[Klatuu]

You should not be storing calculated fields in a table. It violated database
normalization rules. Storing calculated fields only wastes time and disk
space and have a high likelyhood of becoming incorrect. You should present
the value as a calculation on forms or reports.

 

[Revned]

thank you Klatuu very nice and helpful ideas

You should not be storing calculated fields in a table. It violated database
normalization rules. Storing calculated fields only wastes time and disk
space and have a high likelyhood of becoming incorrect. You should present
the value as a calculation on forms or reports.