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

  • Thread starter Thread starter outdoorsinoregon
  • Start date Start date
O

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

primary key - concatenated or autonumber? 6
Report based on various criteria 1
Form and Subform for single ID 1
Creating a report from a query using drop down box parameters 1
HOW DO I TRACK ATTENDANCE 2
Transfer fields to another table 3
What do I do with old records? 8
MTV Launches 'Classic' Channel Dedicated to 1990s 4

Back
Top