Wildcard search problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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...
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help on wildcard expression 2
Access Dcount (multiple criteria) 3
Only enter a certain number of values in a text box? Access 2000 5
txt search box returns all records when wildcard is entered 3
Database Import Duplicate Issue 0
Wildcard Table 4
Wildcards in IIF statements 3
Wildcards in SumIF formula 1

Back
Top