What is the best way to set up tables to calculate up to 6 totals

[outdoorsinoregon]

I am creating a database that will be used to track youth for 6 years in a
certain program. The youth can get up to 6 points, one point for each year
enrolled in the program. The youth could redeem only the points they have
accrued once a year but could also save all the points. What would be the
best way to capture this information? I created a youth information table, a
total point table, and a total point redeemed table. I then created a query
to calculate this. I am not sure if I am going about this the right way. I
am relatively new to Access and have taken some training, but I am stuck on
this piece.

This table will be used for many years to come and will be constantly adding
new youth.

Any information would be greatly appreciated.

 

[Arvin Meyer [MVP]]

That seems to be the correct way to do it. It's hard to say exactly without
knowing the exact table structure and the relationships.

 

[Coderz]

I suggest you create the database and all the necessary tables first. Then
try it yourself. If you have problem with it them ask for help again.

http://www.sourcecodester.com - Download free source code.