How can I get a calculated value from my form into a field in the ecnalch 14.07.2006 01:09:01 I have created several calculated values in a subform and I was able to total these on the main form. Now I want to move these totals from the main form into a field in the database before I enter another record. Can anyone help me?

Re: How can I get a calculated value from my form into a field in the fredg <fgutkind[ at ]example.invalid> 14.07.2006 02:11:40 On Thu, 13 Jul 2006 18:09:01 -0700, ecnalch wrote: [Quoted Text] > I have created several calculated values in a subform and I was able to total > these on the main form. Now I want to move these totals from the main form > into a field in the database before I enter another record. Can anyone help > me? Sure. Don't! Storing calculated data is not necessary, and goes against the rules of relational database design. Besides wasting memory space, it is susceptible to error if one of the components of the calculation needs to be changed. As long as you have the various parts of the calculation saved, whenever you need the total, re-calculate it, on a form, in a query, or in a report. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail

RE: How can I get a calculated value from my form into a field in the Klatuu 14.07.2006 20:01:01 fredg is correct. "ecnalch" wrote: [Quoted Text] > I have created several calculated values in a subform and I was able to total > these on the main form. Now I want to move these totals from the main form > into a field in the database before I enter another record. Can anyone help > me?