populate calculated text box from main form

  • Thread starter Thread starter Revned
  • Start date Start date
R

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
 
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.
 
thank you Klatuu very nice and helpful ideas

Klatuu said:
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.
Click to expand...
 
Back
Top