The issue isn't whether or not it's possible to store them (it is). The
issue is whether or not you should store them (you shouldn't).

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> Thanks indeed....yes I do know how to calculate in a form and/or query.
>
[quoted text clipped - 24 lines]
> >>
> >> Bernard
Thanks I accept that although I am not clear as to why one shouldn't.
How is it possible then to store in the table via the form?
Thanks for all the assistance.
Bernard
> The issue isn't whether or not it's possible to store them (it is). The
> issue is whether or not you should store them (you shouldn't).
[quoted text clipped - 30 lines]
>> >>
>> >> Bernard
Douglas J. Steele - 21 Oct 2005 00:25 GMT
As fellow Access MVP John Vinson likes to say "Storing calculated data
generally accomplishes only three things: it wastes disk space, it wastes
time (a disk fetch is much slower than almost any reasonable calculation),
and it risks data validity, since once it's stored in a table either the
Total or one of the fields that goes into the total may be changed, making
the value WRONG."
One approach for "how" is to have 2 fields on the form: one visible, and one
hidden. Bind the hidden field to the appropriate field in the form. In the
form's BeforeUpdate event, put code to transfer the value that's in the
visible field to the hidden field.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> Thanks I accept that although I am not clear as to why one shouldn't.
> How is it possible then to store in the table via the form?
[quoted text clipped - 38 lines]
>>> >>
>>> >> Bernard
Arvin Meyer [MVP] - 21 Oct 2005 03:42 GMT
In addition to Doug's method, you can write a few lines of code that check
for the existence of the other elements of the calculation then fills the
the calculation in the bound text box.
If Not IsNull(Me.txtField1) Then
Me.txtField3 = Me.txtField2 * Me.txtField1
End If
Doug already told you why not to. Good database design is important for a
smoothly running application.

Signature
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
> Thanks I accept that although I am not clear as to why one shouldn't.
> How is it possible then to store in the table via the form?
[quoted text clipped - 36 lines]
> >> >>
> >> >> Bernard
Bernard Murphy - 22 Oct 2005 09:16 GMT
Thanks very much ......that explains the entire position very well.
Thanks again to all
Bernard
> In addition to Doug's method, you can write a few lines of code that check
> for the existence of the other elements of the calculation then fills the
[quoted text clipped - 51 lines]
>> >> >>
>> >> >> Bernard