Jump to content
  • 0

Updating the total of a field from individual entries



Part of our application tracks competition points for each individual. I have a table with the person and points per competition. This table will have multiple entries for each person with the points they received for that competition.

I would like to keep a running total of points in the person's individual record to be used for a variety of functions other than simply reporting the totals in a report.

So, any suggestions on how I can update the total number of points for a person each time that person is entered into the details table?


Link to comment
Share on other sites

3 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...