force a value as seen in a control into a field

  • Thread starter Thread starter beppe005
  • Start date Start date
B

beppe005

I have the following problem.
A textbox shows a dsum operation, this value should be seen also in the
table and query with the same field name.

I mean that I have a form, in design view I click on field list, select t
the field [total hours] and put on the mask, then I go in properties and for
control source I tipe "=dsum.....". This dsum calclulates a total among
submasks with the same ID, I enter the hours in the submasks and the
calculate control/field [total hour] shows me the total).

Now I see the correct value for [total hours], but if I run the table (wich
originates the query) or the query (wich originates the form) I cannot see
any value for the field [total hours].

I wonder if there is a way to "force" the value of that dsum into the field
named [total hours].

TIA

Beppe
 
This value should only be stored in the table if there is a valid reason why
sometimes it should *not* be the same as the actual sum of the hours.

This article explains why calculated fields belong in queries, not tables,
and also explains how to store the calcuated result if you decide you do
need to do that:
Calculated fields
at:
http://members.iinet.net.au/~allenbrowne/casu-14.html
 
Back
Top