Hi everybody
I am working on a Database for our Sailing club.
I have built a report that is not working the way it should:
Members of the club are supposed to work 10 hours/year on common labor (cleaning, boats maintenance, etc.)
Members of the same family are allowed to combine their “Due work hours” (i.e. one family member works 15 hours and the other one only 5 hours)
On the report the “Worked Hours” are added as (∑), the result (∑ geleistet) is subtracted from the “Due hours” (Sollstunden) and the result appears as “Rest”.
The problem is that Access adds 10 more “Due hours” for every new line of worked hours.
(see the red circles)
How can I build this report so that the “Due Hours” are added for all family members, but that Access does not add 10 new “Due Hours” for every new line in the detail section of the report?
Any suggestion?