Question on Queries

[jrlane]

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.

 

[jrlane]

OI forgot to add that the field with the occasional null is a date field.

 

[zilxodarap]

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.

Liz

 

[jrlane]

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.

 

[zilxodarap]

If it's a Paradox table (.db file), a blank field is blank, not NULL. SO:

SELECT *
FROM table
WHERE field=''

...would get you everything where that field is blank.

Liz

 

[jrlane]

Great! Thanks for the help!