Wildcards?!

[esx_raptor]

Hey sup guys check this out:

iif(condition,then,else)

Alright, I'm cool with the condition, however, when I try to use the "Like *" wildcard in the "then" part it won't work (same with else).

Is there another way to do this?

kthx

[Rainlover]

The >Then< and the >Else< require a Single Result or perhaps a Function.

What are you trying to do with the wild card.

[esx_raptor]

I have a drop-down list in an application in which the user can pick or write a name from that list. If he chooses a name and presses a button, all the instances of that name in a table will be displayed. However, if he doesn't put any name in that field (the empty string ""), it should display all the names in the table. Thus:

iif (name()="", like *, name())

But that is not working, like I mentioned.

[pbaldy]

Would this work for you?

http://www.mvps.org/access/queries/qry0001.htm