formula in a form in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form in which I enter data that is stored in a table. The control
source of the text box directs the data to a field in the table. If I put a
formula as the control source of a text box, the result shows up in the form
but does not populate in the table. For example; I have a text box that I
enter numbers in inches. I have a second text box that converts the entry in
inches to centimeters. The formula works but the only entry that populates
the table is the one I enter not the result of the formula. How do I direct
the result of the formula to the table.
 
Storing a calculated result in a table is generally frowned upon. Tables
should contain bits of information (fields) that are not dependent on any
other field. You might want to read up on database normalization for some
insight. If you store a calculated field in a table, and one of the pieces
of information changes, the other pieces will not be updated and your data
will eventually become useless. It's better to store your number of inches
in a field (as you're doing now), and then use a calculated field anywhere
that you need to show the conversion to centimeters.
 
Back
Top