Using query criteria

  • Thread starter Thread starter Rob W
  • Start date Start date
R

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?
 
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
 
Back
Top