Multiple Selection Criterial Query some with NULL fields

[Joe M.]

I have a form containing several text boxes which supplies selection
criterial for several fields in a query. Usually data is not entered in all
the text boxes. I use a default astrick (*) to make sure I get results from
the query for the fields left blank. However 1 field in the query sometimes
is blank for some records. When the astrick is entered in this field, only
non-blank records are reuurned. I need ALL records for this field returned
whether it is blank or not. Can someone help with this?

Many thanks,
Joe M.

 

[Duane Hookom]

You can add a new column to your query design like:
NewField1: Field1 & ""
This converts nulls to a zero-length-string which can be queried with the
Like "*".