Problem with IIf in query

[mac]

Hi

Can someone tell me why the True part does not return any records but
the False part does in the following query:

Like
IIf([Forms]![SelectReports]![ExcludePLT].[Value]=True,([Forms]![SelectReports]![DocTypeCombo]
& "*" And <>".plt"),[Forms]![SelectReports]![DocTypeCombo] & "*")

It is definitely a syntax error because if I run the 2 parts queries
separately they both return the records I am after.

This works:
Like [Forms]![SelectReports]![DocTypeCombo] & "*" And <>".plt"

So does this:
Like [Forms]![SelectReports]![DocTypeCombo] & "*"

Thanks in advance

Mark

 

[Duane Hookom]

You can't place the "And <>"." inside the IIf(). You can use two IIf()s with
the same condition argument and place the "And <>" between them.

 

[mac]

Hi Duane

Thanks for the reply!

I have used this:

Like [Forms]![SelectReports]![DocTypeCombo] & "*" And
<>IIf([Forms]![SelectReports]![ExcludePLT]=True,".plt","*")

I wasn't sure what to put in the False part of the IIf

And <>"*" Seems to work, is that correct ?

Thanks again

Mark

 

[Duane Hookom]

Test a bunch of different values in your controls to make sure it works as
expected.