Results 1 to 6 of 6

Thread: IsNotNull???

  1. #1
    Join Date
    Mar 2004
    Posts
    56

    Unanswered: IsNotNull???

    I have a fairly complicated mod that I am trying to run and essentially it works but if the formula runs into a blank field or record the output is #Error. I was told to put isnotnull in the criteria but I only see IsNull in the functions.

    Essentially is there something I can put into the Criteria field telling it to ignore Null values?

    Thanks ahead of time.

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346

    Re: IsNotNull???

    Try:

    WHERE NOT Field IsNull
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

  3. #3
    Join Date
    Mar 2004
    Posts
    56

    Re: IsNotNull???

    Originally posted by SCIROCCO
    Try:

    WHERE NOT Field IsNull

    I entered in WHERE NOT Field IsNull into the criteria field and got the error "Data Type mismatch in criteria expression"

    I am using Access 2k

  4. #4
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346

    Re: IsNotNull???

    Sorry IsNull is a function type it in like this instead

    WHERE Not IsNull(Field)
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You guys are thinking to hard.



    WHERE field IS NOT NULL

  6. #6
    Join Date
    Mar 2004
    Posts
    56

    Re: IsNotNull???

    Originally posted by SCIROCCO
    Sorry IsNull is a function type it in like this instead

    WHERE Not IsNull(Field)
    Ok, I entered in:

    WHERE NOT IsNull([Combined_PS]![VNDAD1])

    I recieve the error:

    the expression you entered contains invalid syntax, you may have entered an operator, such as the + operator, in an expression without a corresponding operand.

    So, I tried "epr1: WHERE NOT IsNull[Combined_PS]![VNDAD1]" and recieved Data Type mismatch in criteria expression.

    I should note

    Field: sample: RemoveGarbage([Combined_PS]![VNDAD1])
    table:
    sort:
    show: {check}
    criteria: (see above)

Posting Permissions

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