What is the proper Access Query/SQL Statement in Access to get a result set with no nulls and no zero length strings (in a specified field) in the result set. As an example below I'd like to find all contacts from tblContact with a title specified (i.e. no nulls or zero length strings):
SELECT DISTINCTROW tblContact.*
WHERE (((tblContact.Title) Is Not Null))
WITH OWNERACCESS OPTION;
Can't seem to get this one.. Thoughts?