Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106

    Unanswered: Display 0 instead of a blank on a report

    Hi,
    I created a report in MS Access 2003 that is pulling the info out of a query. I would like to print 0 where there is no data in a numeric field. Please help.

    Thanks
    Mo
    Mo

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try using the NZ function around the columns in the query OR the data source of the control(s) on the report
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106
    Thanks for your help. It worked great.
    Mo

Posting Permissions

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