is null RRS feed

  • Question

  • good morning. I am not an expert but am building a data base for my cattle records.

    in an older version of access I could use is null to produce a list of cattle not sold or not died.

    I am trying to start again with this latest access version and is null now requires an expression.

    but why and what expression.

    hope this makes scence

    thank you


    Saturday, April 22, 2017 6:27 AM

All replies

  • It should work the same way in all versions of Access. The condition Is Null should be entered in the Criteria row of a query based on your cattle table. For example:

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Proposed as answer by Chenchen Li Monday, April 24, 2017 2:44 AM
    Saturday, April 22, 2017 12:29 PM