Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Nov 2006
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    emty fields (access 2003)

    trying to count empty fields of a table (text) - what is the way to do it ? isnull(), isempty(), ismissed(), "" -don't work

    thank you
    Alex

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: emty fields (access 2003)

    Are you doing this counting in a query?

    A truly empty field has a Null value, and you can test for them with Is Null on the criteria line of a query.

    Often tables can contain Zero Length Strings that look empty. To test for them you need to use ""

    To test for both use: Is Null or ""
    Regards
    John



Posting Permissions

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