Hey all. I'm rather new to Access. I do have a good understanding of relational databases and such (Took a few college courses), but I need some help with this.
Overview:
- It's a database for tracking the performance of Soldiers in our unit (US Army, active duty Soldier).
- Includes the main form "SM_Form" with several tabs on it that each contain subforms for data related to the Soldier (Physical fitness scores, weapons qualifications, etc.)
- One of those tabs is the "OML_Subform" which calculates the raw scores from each of the other tabs, and assigns a numeric value. This value is used to "rank" Soldiers' merit. Higher score = higher on the OML (Order of Merit List). Higher on the OML = first to be picked for special schools, training, etc.
Intent:
I've more-or-less got the db working properly. It's at about 80% where I want it.
I would like to be able to generate a report that simply lists a Soldier's basic info (Rank, Name, and calculated total of the OML scores).
Since I'm told it's not a good idea to store calculated values in a db (all of the OML scores are calculated from the raw scores), I'd assume the report would have to make the calculations each time the report is generated.
I just don't know enough about reports.
Issue I'm having:
These are relatively simple calculations to convert raw scores to OML scores (as listed in the "OML_Subform" on the DB), but how do I make a report do it?
Please, view the attached DB to get a better understanding of what I'm talking about. (Converted to 2003 format)
Overview:
- It's a database for tracking the performance of Soldiers in our unit (US Army, active duty Soldier).
- Includes the main form "SM_Form" with several tabs on it that each contain subforms for data related to the Soldier (Physical fitness scores, weapons qualifications, etc.)
- One of those tabs is the "OML_Subform" which calculates the raw scores from each of the other tabs, and assigns a numeric value. This value is used to "rank" Soldiers' merit. Higher score = higher on the OML (Order of Merit List). Higher on the OML = first to be picked for special schools, training, etc.
Intent:
I've more-or-less got the db working properly. It's at about 80% where I want it.
I would like to be able to generate a report that simply lists a Soldier's basic info (Rank, Name, and calculated total of the OML scores).
Since I'm told it's not a good idea to store calculated values in a db (all of the OML scores are calculated from the raw scores), I'd assume the report would have to make the calculations each time the report is generated.
I just don't know enough about reports.
Issue I'm having:
These are relatively simple calculations to convert raw scores to OML scores (as listed in the "OML_Subform" on the DB), but how do I make a report do it?
Please, view the attached DB to get a better understanding of what I'm talking about. (Converted to 2003 format)
