I need some advice about a project for my hubby. I have mucked around with Access for probably around 10 years, and I can usually find the answers to what I need in forums like this and other web places, or if I'm lucky someone better with it works in another department. This time though I think I'm in over my head!
So Hubby is a teacher and advisor to a club at his school. His students have to reach a certain number or percentage of points to be able to participate in District, State, and National conference. He also just needs a database with their info, such as contact, grade, did they pay their dues, etc.
Tables I have so far:
tblFBLA_Membership-all the students, contact information, etc.
tblEvent_Points this contains the different categories that events can fall into and how many points that category is worth, such as Regular Meeting 50 points.
tblEvents this contains the actual events, its category and how many points it is, for example January Meeting is Regular Meeting and is worth 50 points.
tblBonus_Points is used for when kids get certain ranks at district and state conference, since these points aren't available to every student these points are not to used to calculate total
possible points available when I need to calculate percentage.
tblCertification_Points contains "BAA" levels, the points worth and the grade level the student must achieve that level by, for example by the end of grade 10 a student have completed
BAA Future and BAA Business. What complicates things with this is that since these are required certifications, if a student hasn't met their grade requirement those points have to still be used to calculate the total possible points available.
tblEvent_Participation has the event name, the student who attended and the points. This is the one I will use to calculate how many points a student has accumulated at "regular" events.
I have a query based on tbleEvent_Participation that sums how many points each student has received, and one based on tblEvents that sums how many points are possible based on these "regular" events.
My snag is with a few different things. The certifications requirements, and the percentages.
I have tried a few different ways of querying and I can't get that percentage to calculate.
And I'm not even sure how to begin to go about getting the certification requirements to work the way he wants.
So Hubby is a teacher and advisor to a club at his school. His students have to reach a certain number or percentage of points to be able to participate in District, State, and National conference. He also just needs a database with their info, such as contact, grade, did they pay their dues, etc.
Tables I have so far:
tblFBLA_Membership-all the students, contact information, etc.
tblEvent_Points this contains the different categories that events can fall into and how many points that category is worth, such as Regular Meeting 50 points.
tblEvents this contains the actual events, its category and how many points it is, for example January Meeting is Regular Meeting and is worth 50 points.
tblBonus_Points is used for when kids get certain ranks at district and state conference, since these points aren't available to every student these points are not to used to calculate total
possible points available when I need to calculate percentage.
tblCertification_Points contains "BAA" levels, the points worth and the grade level the student must achieve that level by, for example by the end of grade 10 a student have completed
BAA Future and BAA Business. What complicates things with this is that since these are required certifications, if a student hasn't met their grade requirement those points have to still be used to calculate the total possible points available.
tblEvent_Participation has the event name, the student who attended and the points. This is the one I will use to calculate how many points a student has accumulated at "regular" events.
I have a query based on tbleEvent_Participation that sums how many points each student has received, and one based on tblEvents that sums how many points are possible based on these "regular" events.
My snag is with a few different things. The certifications requirements, and the percentages.
I have tried a few different ways of querying and I can't get that percentage to calculate.
And I'm not even sure how to begin to go about getting the certification requirements to work the way he wants.