Help on wildcard expression

  • 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
 
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
Click to expand...

Like IIf(IsNull([Forms]![Structure Schedule Master Update Dates]![Lot
Number]),"*",[Forms]![Structure Schedule Master Update Dates]![Lot
Number])
 
(Possible solution in your earlier thread:)

It sounds to me that you want criteria something like:

WHERE ...
( ( Field4 = [Forms]![MasterForm]![TxtBx4] ) OR
( [Forms]![MasterForm]![TxtBx4] Is Null ) ) AND
( ( Field5 = [Forms]![MasterForm]![TxtBx5] ) OR
( [Forms]![MasterForm]![TxtBx5] Is Null ) ) AND
( ( Field6 = [Forms]![MasterForm]![TxtBx6] ) OR
( [Forms]![MasterForm]![TxtBx6] Is Null ) )
 
Back
Top