Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2002
    Posts
    7

    Unanswered: would like blank field to display $0.00

    I have an unbound text box called 'payment total'. The control source is
    =Sum([paymentamount])
    It works fine but when 'paymentamount' is $0.00 the 'payment total' field is blank and as a result my balance field is also blank.

    I've tried, Sum(Nz(payment amount,0))
    but that returns a #name error.

    How do I get the 'payment total' field to display $0.00 instead of being blank?

    Thanks for any help.

  2. #2
    Join Date
    Dec 2001
    Posts
    2
    Try this:

    = Nz(Sum([paymentamount]); 0)


    Gio

  3. #3
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama
    Posts
    12
    I think I would try:

    = Sum(Nz([paymentamount],0))

    HTH
    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama

  4. #4
    Join Date
    Nov 2001
    Posts
    336
    Try

    FormatCurrency(NZ(totalamount,0))

    HTH, Igor

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •