Query results with "no Nulls" and "no blanks" values in certain fi

V

vassilis

Hi
there is a query joining two tables and im looking a way to say No to those
records if some specific fields from the second table ( for example a date
field) , its value is Null or blanlk....
Thanks
 
J

Jerry Whittle

If it's a date or number datatype, it can't have empty strings or spaces.
Therefore Is Not Null in the criteria is enough.

If it's a text or memo field you need to check for Nulls, zero length
strings (AKA blanks or empty strings), and possibly spaces which look like an
empty field. In those cases the following criteria should catch them:

Is Not Null Or Not "" Or Not Like " *"
 
F

FL

What does "a way to say no" mean?

Open your query.

To get date records from your second table with blanks indicate Is Null in
the criteria field.

To get date records from your second table with no blanks indicate Is Not
Null in the criteria field.

Do this for each field that you require select information. Such as your
Date field that you mention.
 
Top