Wildcard search problem

T

titlepusher

This won't work!

This is in a Query window in the criteria box of a field.

IIf([Forms]![Structure Schedule Master Update Dates]![Lot Number] Is
Null,Like "*",[Forms]![Structure Schedule Master Update Dates]![Lot Number])

What I'm trying to do is be able to filter records.. if I type in the entry
then use what I typed.. otherwise show all records.

If I just do the Like * then I get all records like what I type in .. if I
type in "44" I also get records with "4" Therefore... Trying to do the
above expression that I can't make work...
I put a post in earlier with a more complete desc in the Queries section
.... search on "wild card" ..2 words.
HELP
 
J

Joan Wild

titlepusher said:
This won't work!

This is in a Query window in the criteria box of a field.

IIf([Forms]![Structure Schedule Master Update Dates]![Lot Number] Is
Null,Like "*",[Forms]![Structure Schedule Master Update Dates]![Lot
Number])
Click to expand...

[Forms]![Structure Schedule Master Update Dates]![Lot Number] Or
[Forms]![Structure Schedule Master Update Dates]![Lot Number] Is Null

Access will change it all around once you save.
 
T

titlepusher

You are WILD! Thank you... I fought this all day.... You ended a
frustrating ordeal for me. Thanks much.

Joan Wild said:
titlepusher said:
This won't work!

This is in a Query window in the criteria box of a field.

IIf([Forms]![Structure Schedule Master Update Dates]![Lot Number] Is
Null,Like "*",[Forms]![Structure Schedule Master Update Dates]![Lot
Number])
Click to expand...

[Forms]![Structure Schedule Master Update Dates]![Lot Number] Or
[Forms]![Structure Schedule Master Update Dates]![Lot Number] Is Null

Access will change it all around once you save.
Click to expand...
 
V

Van T. Dinh

Please do not multi-post your question in different newsgroups. Use
cross-posting instead if you want your question to appear in different
newsgroups. This way, you and potential respondents can see all replies by
looking at one newsgroup only and potential respondents don't waste time
offering the same solution (like I did in Queries).

Please see: http://www.mvps.org/access/netiquette.htm for proper use of
these newsgroup.
 
Top