WildCard in IIF Statement

[Guest]

My query looks at a textbox from a form as part of an IIF statement as
criteria in a query.
[CorpID] = IIF([textbox] = "a410132", Like "a*", [textbox])

When the statement is true, no records are returned, it should return all
records. A false statement returns the correct value.

What am I doing wrong? Is there any easier way to perform this query?

 

[Ken Snell \(MVP\)]

You cannot use Like in the True or False argument of the IIf function. Try
this:

[CorpID] Like IIF([textbox] = "a410132", "a*", [textbox])

 

[Guest]

Awesome!! That worked perfect!!

Thanks so much!

You cannot use Like in the True or False argument of the IIf function. Try
this:

[CorpID] Like IIF([textbox] = "a410132", "a*", [textbox])
--

Ken Snell
<MS ACCESS MVP>

My query looks at a textbox from a form as part of an IIF statement as
criteria in a query.
[CorpID] = IIF([textbox] = "a410132", Like "a*", [textbox])

When the statement is true, no records are returned, it should return all
records. A false statement returns the correct value.

What am I doing wrong? Is there any easier way to perform this query?