Results 1 to 3 of 3
  1. #1
    janmack79 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    30

    Total Column Not Summing Fields


    Hi I am trying to sum up two revenue fields from a table into 1 Total column and for some reason it just keeps coming up blank. I have never run into this before on summing in a query so wondering what could be wrong, both fields are formatted as a number so it's really odd. Here is how I have the query set up and the results I get when I run it....
    Attached Thumbnails Attached Thumbnails Capture.PNG   Capture 1.PNG  

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    a NULL + any # = NULL

    use NZ(Field,0) to get zeros

    Sum(NZ(Field,0))

  3. #3
    janmack79 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    30
    Yes thank you so much. Its been a while since I have had to create a sum query and forgot about null values!!

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

Similar Threads

  1. Summing group total of mileage
    By gemadan96 in forum Reports
    Replies: 1
    Last Post: 07-05-2014, 10:12 AM
  2. Replies: 3
    Last Post: 05-05-2014, 10:52 PM
  3. Summing a query column help
    By Eskoraczewski in forum Access
    Replies: 1
    Last Post: 02-01-2014, 04:27 AM
  4. Need help regarding forms and 'summing a total'.
    By JackCampion in forum Forms
    Replies: 2
    Last Post: 09-17-2012, 05:03 PM
  5. Summing a column
    By nashr1928 in forum Forms
    Replies: 2
    Last Post: 05-10-2010, 05:42 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