Results 1 to 3 of 3
  1. #1
    angie is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Dec 2013
    Posts
    232

    Adding three currency text box for a total

    I have three text box that are set as currency as the format , default value ( blank). I would like to add the totals together. I tried the following but if the text box is blank then nothing is added but if I put 0 in the text box it works but I do not want anything showing in the field if there is no amount



    i tired.
    =[price]+[price1]+[price2]
    as long as there is a amount in each field it works but if one is blank it doesnt

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    use Null to Zero

    =nz([price])+nz([price1])+nz([price2])

  3. #3
    angie is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Dec 2013
    Posts
    232
    Quote Originally Posted by ranman256 View Post
    use Null to Zero

    =nz([price])+nz([price1])+nz([price2])

    Works Great Thank You

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

Similar Threads

  1. Replies: 2
    Last Post: 03-06-2016, 04:23 AM
  2. Currency formatted Text Box Question
    By data808 in forum Access
    Replies: 4
    Last Post: 05-09-2014, 12:50 PM
  3. Currency Columns not adding up
    By WKU in forum Access
    Replies: 2
    Last Post: 05-07-2014, 09:10 AM
  4. Replies: 5
    Last Post: 12-21-2013, 11:19 AM
  5. Currency/text display issues
    By Akazuba in forum Access
    Replies: 3
    Last Post: 04-20-2011, 07:51 AM

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