Results 1 to 3 of 3
  1. #1
    WKU is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Oct 2013
    Posts
    12

    Currency Columns not adding up


    I have a sharepoint list linked into my access database and every time when I work with queries and try to add up them up it causes the information to display in a textstring. I have no idea what to do in order to resolve this issue. For example, instead of $1,000+$5,000=$6,000 it will show 1,0005,000 as one string but not add them up.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I don't know much about SharePoint. Why is data formatted with $ and comma?

    Try:

    CCur([field1])+Cur([field2])

    or

    CDbl([field1])+CDbl([field2])

    Be aware, conversion functions will error on Null.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Also, the default format for a currency field IS: $ and commas. but they can be changed to a regular number format in the properties.

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

Similar Threads

  1. Adding new columns of sign
    By yossik in forum Access
    Replies: 1
    Last Post: 10-15-2013, 12:26 AM
  2. Adding Columns in a Query
    By racefan91 in forum Queries
    Replies: 5
    Last Post: 10-01-2013, 02:34 PM
  3. Replies: 2
    Last Post: 03-23-2011, 11:43 AM
  4. Adding columns that contain blanks.
    By Tony McGuire in forum Access
    Replies: 11
    Last Post: 05-31-2009, 12:58 PM
  5. Adding Two Columns
    By arthura in forum Queries
    Replies: 6
    Last Post: 05-01-2009, 08:38 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