populate calculated text box from main form

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.
--
Dave Hargis, Microsoft Access MVP


"Revned" wrote:

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

thank you Klatuu very nice and helpful ideas

"Klatuu" wrote:

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.
--
Dave Hargis, Microsoft Access MVP


"Revned" wrote:

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