If in a query there are multiple "checks" (ie., fields selected), but with no filter criteria, and one of the fields is null is the record dropped from the result? Thanks.
Paradox tables can't have NULL values, so, no, the row isn't dropped. If you're using a plain checkmark (not checkplus), then one record for each unique combination of values in the checked fields is returned.
In Access (the database to which I am converting this appliction, a field can be null, "blank" (ie. an actual alpha space in the field, or an "empty string"). Looking at the Paradox table the field appears to be blank. What do you suppose is in it? Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.