database field calculations add to a field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Helpless jerry - 31 Mar 2006 02:59 GMT

Here Go's I have a table employeeID,Fname,LName. And another called
Points.Points has PointsID,AcquiredPoints,UsedPoints,AvailablePoints. Ihave
a form with employeeID,Fname,Lname,and a button called Add Points this opens
a form to enter points this is where I can't find a way to add points to the
points. what I am saying I enter a amount like 200 points and in the table it
puts 200 points in the field called acquiredPoints. But now I want to add to
that field more points like it has 200 Points in the field I want to enter
300 more points and it add it to the field, and the field now says I have 500
points. Now I know I could just change it to 500 points but I just want it to
do it automatic. I have tried every thing I know. which is not much. Please
Help. the rest of the database i can do if i had this part. Bottom line.
field add points 200 +300 = 500. field UsedPoints - 200, availablepoints
acquired points - usedpoints. have it all do this.

Reply to this Message

Ed Robichaud - 31 Mar 2006 05:06 GMT

Each "point" entry is a record. Your Points table should be:

tblPoints
pointID - primary key
employeeID - foreign key related to tblEmployees
AcquiredPoints
UsePoints
PointDate
etc.

Available, Total Used, Total Acquired, etc. are all calculated values and
need not (should not) be stored. Just create unbound controls (with the
appropriate calculated expressions) on your forms & reports to show those
values.

-Ed

> Here Go's I have a table employeeID,Fname,LName. And another called
> Points.Points has PointsID,AcquiredPoints,UsedPoints,AvailablePoints.
[quoted text clipped - 17 lines]
> field add points 200 +300 = 500. field UsedPoints - 200, availablepoints
> acquired points - usedpoints. have it all do this.

Reply to this Message