Results 1 to 4 of 4
  1. #1
    Join Date
    May 2021

    Problem with details section of report addiing to many rows

    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?
    Attached Thumbnails Attached Thumbnails Screenshot 2021-05-01 185322.png  
    Last edited by Captain_Frog; 05-02-2021 at 06:47 AM.

  2. #2
    Welshgasman is online now Expert
    Windows 10 Access 2007
    Join Date
    Jan 2017
    Swansea,South Wales,UK
    Looks to me like you have Removed Duplicates and those lines will have the extra values?
    Please, please use # when posting code snippets.
    Cross Posting Etiquette:
    Debugging Access:

  3. #3
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Kelowna, BC, Canada
    Can you show the report in design view and its record source? Looks like you get the due hours duplicated for each day of actual work done, so you will need to either use a subreport for the actual work or replace the sum of due hours by a simple dSum grouped by family id to bypass the extras on the report.

    Vlad Cucinschi
    MS Access Developer

  4. #4
    Join Date
    May 2021
    Click image for larger version. 

Name:	Screenshot 2021-05-02 222435.png 
Views:	12 
Size:	17.4 KB 
ID:	45127Click image for larger version. 

Name:	Screenshot 2021-05-02 222310.jpg 
Views:	11 
Size:	84.6 KB 
ID:	45128

    Hi Vlad
    Thank you for your comments
    I'm not sure you will be able to see somthing on these screenshots
    [Due hours] (Pflichtstunden) are calculated by a function (First Year) : 10 hours for old members and proportionaly less for members who join in during the running year. This funtion has an argument taken from the column [Eintrit] (Entry year).

    I will explore your suggestions in the next days

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 04-16-2018, 07:43 PM
  2. Replies: 3
    Last Post: 07-05-2017, 11:35 AM
  3. Replies: 3
    Last Post: 03-16-2016, 05:47 AM
  4. Page Break at end of Details section
    By noweyout in forum Reports
    Replies: 3
    Last Post: 04-21-2011, 12:02 PM
  5. Replies: 26
    Last Post: 11-06-2009, 10:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums