Results 1 to 7 of 7

Sum Query Fields in an Access Report

  1. #1
    melonwand is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    19

    Sum Query Fields in an Access Report

    I have been trying to figure this out can someone please tell me what I have wrong in this equation. It works in 3 other places on the same report but for some reason particular field will not sum. This is what I have in the "Control Source" of the report field.

    =Sum([4000GCPConsult]+[4100GCPTravel]+[4200GCPPM]+[Expenses])

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,321
    If it's working elsewhere on the same report, it's probably the location. Where do you have it? Sum won't work in the page footer, only group and report footers.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  3. #3
    melonwand is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    19
    All of the sums are being calculated in the report footer. I'm completely baffled by this.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,321
    You're saying that formula works in one place on the report but not another? What error do you get? Can you post the db?
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  5. #5
    melonwand is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    19
    No error appears it shows as $0.00 and there is data in the fields I'm adding. Unfortunately, I cannot post the DB.

  6. #6
    melonwand is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Feb 2011
    Posts
    19
    Thank you for your help. I turns out that it was hidden in plain sight. The fields that were being calculated were not all populated with a "0" so it was unable to sum the fields.

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,321
    Glad you got it sorted out. I should have mentioned that as a possibility earlier, but it threw me off when you said the same calc was working elsewhere on the report. I assume you used the Nz() function on the values, or perhaps make sure Nulls couldn't get into the data in the first place.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

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

Similar Threads

  1. Move fields to the right in a report
    By degras in forum Reports
    Replies: 1
    Last Post: 01-20-2011, 06:40 AM
  2. Replies: 7
    Last Post: 11-13-2010, 06:08 AM
  3. Where Used report Access Query
    By AccessLes in forum Access
    Replies: 3
    Last Post: 06-26-2010, 12:07 PM
  4. Replies: 3
    Last Post: 05-21-2010, 02:57 PM
  5. Vertical Fields on Report
    By jocallahan in forum Reports
    Replies: 3
    Last Post: 10-09-2008, 06:22 PM

Tags for this Thread

Posting Permissions

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