Results 1 to 3 of 3
  1. #1
    Rick West is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    90

    Sums in Detail area of report

    In a report I am using the underlying query to calculate extended row totals for 2 different values, Value A and Value B. Each are calculated in the query by CostA*Qty or Cost B*Qty and these work just fine. They also relate in the query to a group, like Group 1 or Group 2.

    Then in the report detail area, Group 1 the sum of the CostA*Qty and sum of CostB*Qty work also (text boxes) - BUT I then sum the A total sum and the B total sum into a sub-grand total (text box, again in the detail area) - which works fine unless there is no data in one of the A or B sums.



    Example: Sum A = $1,000, Sum B = $200, Sub Grand Total = $1,200 but if
    Sum A = $1,000 and Sum B = blank, Sub Grand Total = blank too.

  2. #2
    Rick West is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    90

    Nz Function

    I got this solved myself, sorry for the time you spent (if any) on my issue. I added the Nz function to my query so it forced a zero into the row calculated value if it was zero and the report works fine now.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    Thanks for sharing your solution with others here.

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

Similar Threads

  1. Replies: 1
    Last Post: 10-11-2009, 08:31 PM
  2. report detail duplication
    By archie in forum Reports
    Replies: 5
    Last Post: 09-17-2009, 08:51 PM
  3. Space Between Header and Detail in Report
    By tigers in forum Reports
    Replies: 3
    Last Post: 06-23-2009, 12:01 AM
  4. calculating sums in reports
    By Hannu in forum Reports
    Replies: 1
    Last Post: 03-12-2009, 02:59 PM
  5. Report Detail Entry Selection Problem
    By Joe in forum Reports
    Replies: 0
    Last Post: 02-02-2009, 06:55 PM

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