Results 1 to 2 of 2

Thread: ISERROR

  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I have people throwing all kinds of junk in a basic text field where they should be entering an actual number. (This is another program not contolled by me because OF COURSE i would change that!!!!) When the data is returned in my query, I want to take those numbers and do a simple [FIELD] * 1 to convert it to an actual number to join it to another query. Because of the garbage, i return errors on some of the rows. I thought a simple formula simlar to what i would use in excel would do the trick. alas, it's not working as i expected. can someone help get me over my stumbling block? As always, thanks!

    IIF(ISERROR([field] * 1),"",[field] * 1)
    thanks
    christine

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Try using IsNumeric to test and see if the field can be converted to numbers. The IIF construct should work with that, and give you the option to set it to whatever you want, Nulll, 0, 1 or something else.
    Wendell

Posting Permissions

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