Hi,
I'm a personal trainer and new to access. I'm trying to set up a database for my clients and I have a question (I'm not even sure what you would call this or if it is even possible, but I'm hoping so).
Here's my situation:
My clients will buy x number of workout sessions from me when they first sign up. What I'd like to do is input that number of sessions in a box on the client information sheet and then as I enter the date and time of each workout as it happens, have the program subtract that session from the total number of sessions left.
So if Bob has 12 sessions, and we train on Monday and Tuesday, is there a way to have access show that Bob now only has 10 sessions left? Oh, and Bob can also buy more sessions at any time, so I would need to be able to add 5 more sessions onto his running total and have it subtact his workouts from the new number (17-2=15 in this case) without screwing things up.
Is this possible in access? A way to automatically count the number of records and then subtract it from a number that I have inputted? If so, how?
Thanks for your help!