Storing values of calculated field in table

[Wasim Yasin via AccessMonster.com]

I used a calculation in Control Source of field on my form. This field is
bound to a table.But when I open my table and look into that field there is
no data or result of the calculation.How it come in table?
Please help.
Thanx.

 

[Allen Browne]

You cannot have both a field name and a calculation in the Control Source
property of a text box.

To decide which one to use, and how and when to try to synchronize them,
see:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

 

[Wasim Yasin via AccessMonster.com]

Dear Allen
Is there any problem to address given by u? I'm unable to connect at that
address.

 

[Allen Browne]

The reply address is munged to avoid the spam you get from the bots that
read the newsgroups, but the one in the sig below works.

However, we encourage you to post questions here for free help, so everyone
can benefit and give suggestions.

 

[John Vinson]

I used a calculation in Control Source of field on my form. This field is
bound to a table.But when I open my table and look into that field there is
no data or result of the calculation.How it come in table?

Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.

Just redo the calculation whenever you need it, either as a
calculated field in a Query or just as you're now doing it -
in the control source of a Form or a Report textbox.

John W. Vinson[MVP]