Increasing values in table from form.

[matt.calnan]

First of all, I am VERY much a beginner to Access. I have very limited knowledge. I'm trying to set up a database to track client loyalty points. The table would contain the client ID, name, membership date, total points earned, total points spent, points balance (which is earned - spent), and dollar value.

I have two questions. The first thing I'm trying to do is create a form that will let you increase or decrease the points of a client. I have figured out how to create the form, but now I can't figure out how to "add" the points to the "Total Points Earned" column in the table. And how to "Decrease" the points to the "Total Points Spent" column in the table.

I'm also trying to have the "Dollar Value" column in the table auto calculate based on points. The dollar value would increase as points reached certain thresholds. Ie. once you hit 8000 points, you have $10. Once you hit 15,000 points you have $25 dollars.

I have looked everywhere I can think of to find these answers! I just don't know enough of the lingo to figure out exactly what to search for!



Thank you for your help!!

[vicsaccess]

Matt, welcome. A few things first, I'm not sure of your knowledge or future need for this database but a few things come to my mind. I would suggest starting with this page and it should explain a lot as for the overall design and structure. You'll also find many other useful tools and references there.
http://www.rogersaccesslibrary.com/forum/forum46.html
Basically you are needing two things-
To add a value to a field in the table which there are several ways of doing it just depending on how you envisioned it. my thought is increase or decrease by a set number each time of say,5? Then add a command button to the form and in the click event it would be something like text1=text1+5
The second would be to learn how to get calculated values on the fly on your forms. Notice i didn't say your table, you should never store calculated values such as points balance and dollar value in your table that you can do on your forms or reports when needed.
If you'll look over the page attached it will start making since. if you know more details about how you envision being able to increase or decrease the points, give us more details and we'll help and give more direction.