I am trying to build a database for tracking progress over time.
I have a Subjects table that has a unique ID for each subject I am trying to track.
In this table I record the DateStart for the subject, the Deadline for the subject and the UnitsTotal required to complete the subject.
I have arbitrary units of progress that I want to enter each day as UnitsProgress in a Reports table.
I want to make a field in a query that calculates the PercentageProgress based on the summation of the daily UnitsProgress values entered into the Reports table for each SubjectID compared to the UnitsTotal value stored in the Subjects table.
I have tried changing 'group by' to sum UnitsProgress, but it seems to be summating without regard for the SubjectID.
The output I want:
SubName UnitsProgressSum UnitsTotal PercentProgress SubjectX 70 100 70% SubjectY 50 100 50%
What I am getting:
SubName UnitsProgressSum UnitsTotal PercentProgress SubjectX 120 100 120% SubjectY 120 100 120%
thanks