Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005
    Posts
    55

    Unanswered: NZ function problems

    when i use NZ([FieldName],0)
    it converst the field to a text field, for some reason
    any suggestions

  2. #2
    Join Date
    Mar 2005
    Posts
    55
    I figured it out
    its
    Val(Nz([FieldName],0))

Posting Permissions

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