Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Location
    NYC
    Posts
    30

    Cool Unanswered: IsError Function

    Hello there,

    I've used the iserror function in MS Excel many times and have no trouble with it. Now that I want to use it in Access it doesn't seem to work properly.

    I was trying to


    PA / DAILY = VALUE
    2500 / 0 = error
    2500 /100 = 100


    IIF(IsError([PA]/[DAILY]),0,[PA]/[DAILY)


    I could change it to:
    IIF([DAILY]=0,0,[PA]/[DAILY)

    But I was hoping someone can tell my if I'm using IsError incorrectly in Access. I checked the archives but there was never an answer if this is problem with Access.

    Thank you in advance so much!!

    Cheers!

    PS. We demo the Access 2007 and I'm and I hate it.
    Last edited by Wendyc888; 04-13-07 at 18:26.

  2. #2
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    The IsError function in Access is not at all like the IsError function in Excel. In fact, it is only looking at error numbers that are returned from a function, and the function must be written to pass back a very specific code, that is an Err code for actual error codes within Access. The IIF will do you the best, or something like it, within Access.

    Normally within Access, there should not be the chance for the types of errors that could happen much easier in Excel, therefore Microsoft has not provided for that same type of error handling in Access.

    HTH,

Posting Permissions

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