Using query criteria

[Rob W]

When creating a query, what is the specific language to
use in the criteria row to include a field from a form IF
IT HAS A VALUE but exluding the field (and returning all)
if it does not?

 

[Timothy]

Ive used that in a form as well, but I used an open
critera with a *.
heres the syntax that worked

Is Not Null And Like '*'+NZ([Forms]![Search Box]!
[Entry],"something that will never happen")+"*"
this is for a parameter search using * before and after
the word your looking for, so it will find any word in any
field with the characters you asked for.

Hope this helps

Timothy