Results 1 to 3 of 3

Thread: Nz (2000)

  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Nz (2000)

    Hi,

    Some fields of my report have value is Null. I try to use Nz to convert Null value to 0 if there's Null value. But I got the error message: Syntax error in (comma) in query expression. Below is the code that I input:

    Nz([VO by Service Category_Dated.Yes],0)

    Please let me know if the code is wrong or I should use IIf instead of Nz.

    Regards

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Nz (2000)

    If you are using this as the control source for a control on a report, you need to put an = sign in front of it.

    If you are using it in a query you need to create a calculated field with a name then a colon- like this Yes2 : Nz([VO by Service Category_Dated.Yes],0)
    Regards
    John



  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Nz (2000)

    Thanks. It's works.

Posting Permissions

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