Exactly. One way to simplify is to set AllowEmptyStrings to False for Text columns in Access tables. That way, you only have to check for nulls. For example, you won't find null records if you use WHERE col = "". And you won't find empty strings if you use WHERE IsNull(col). You can use implicit conversion to force Access to cast nulls to strings by doing WHERE (col & "") = "" but then you always have to remember to do that, which gets to be a pain.
Originally Posted by Vulcan1500
It's not what you don't know that gets you in trouble. It's what you know that just ain't so. -Mark Twain