sql - How to easily filter my query -
i trying filter query via textbox on form. have in criteria of query:
like "*" & [forms]![form_name]![textbox] & "*" however if textbox blank shows info in query have got text in field. doesn't show data, i.e. fields have no data. possible do?
the way have found have 2 queries 1 filter , 1 without , run code if textbox empty swap query.
just append zero-length string field compare, none of fields null, match *.
where myfield & "" "*" & [forms]![form_name]![textbox] & "*" sql ms-access
No comments:
Post a Comment