Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Displaying 0 in a report with a null value returne (Access97)

    I have a report now that I run and if the result of report is 0 or null it just displays the field as blank. Is there a way I can tell the report that if the value of this field is null then to place a zero in this field. Maybe something like: If Me.[Total] Is Null Then = 0? Any help is appreciated. Thanks

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,340
    Thanks
    1
    Thanked 18 Times in 18 Posts

    Re: Displaying 0 in a report with a null value returne (Access97)

    This may be a combination of 2 things. First of all, use the NZ() function to make the value of the field zero if it is null. If it is a field from the query, you can use: NZ(yourfieldname, 0) for example.

    Then, check the formatting for the field. Make sure the format has a 0 (zero) as the rightmost character.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying 0 in a report with a null value returne (Access97)

    Use the Nz function to return zero when the value is Null.

    Nz([Your FieldName],0)

    You can look up the Nz function in Access Help for more detail.

Posting Permissions

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