Not sure what the difference is between null and empty. If my goal is
to display records which have some entry in a particular column, then
I must exclude those that don't have an entry. Isn't that what not
null does?
For us mere humans there is no difference, but to Access there is a
difference. Quick answer: An empty or blank field may have had data in it
and it was deleted. A null field never had data.
When you use is not null to filter the field, it wont
filter the empty field, so will apear on your list,
so you might think that your criteria doesn't work.
the filter empty field use the <>"".
in your query at the filter you can use in one go "is not
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
