Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2016
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sum issue in Access 2010 database

    I created an Access 2010 table and I appended data from three (3) different sources to it. After the data was added to the new table, I did an update query to change all null values to zero. However, when I use the new table as the basis for a totals query, the data will not sum.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    Is the field in question defined as a numeric field?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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
  •