Sums and forms and storage of data

  • Thread starter Thread starter Clgeigel
  • Start date Start date
C

Clgeigel

I am trying to use a field to both add two number then store said sum in a
field in a table. Basicaly i am setting up a point system that i am using
acess to keep track of. I have the point value that i want ot initially
display in this box which i have wroking. once another data entry point is
accesed, a field named change, by placing the number of points to add i have
set up the points field to show the change in points. i now need it to store
the sum to the points field in the table. any takes on helping me out with
this one?
 
Clgeigel,
Sorry, but I can't figure out what you're trying to say here.
There is an issue about calculated values that may transcend your setup.

If you have 2 bound controls (with numeric values) on a form, and want
to add them together, create a calculated field on the form.
Ex. an unbound field with a ControlSource of...
= NumField1 + NumField2
will always "display" the calculated value.

It is not necessary, or recommended, that you store that value in your
table. As a general rule, don't save a calculed value if it can be
recalculated "on the fly" in any subsequent form, query, or report.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
On Wed, 8 Apr 2009 02:13:01 -0700, Clgeigel

That is bad database design: calculated values don't belong in a
database. Rather they are calculated on the fly in a query (select A+B
as C) or on a form/report with an expression (=A+B).

-Tom.
Microsoft Access MVP
 
Back
Top