SQL Satement Wont Execute

[shamas21]

Hi All

I have the following SQL statement that will not execute.

Can i get someones take on this.

SELECT qrysearch.*
FROM qrysearch
WHERE IIf(IsNull(Forms!Search!tbxDate),[monthly report] Like '*',IIf(Forms!Search!cbxOptionDate="Equals",CDate([Reporting_Year] & "/" & [Monthly Report] & "/01") =Forms!Search!tbxDate));

Thanks

 

[MarkK]

This could be a number of things. Do you get some kind of error message that could narrow things down a little?

 

[MSAccessRookie]

The Standard Format for the IIf Command is something like this:

IIf (TestQuery, ValueifTRUE, ValueifFalse)

Your Format seems to break down to:

IIf (TestQuery, ConditionifTRUE, ConditionifFalse)

for the first IIf and

IIf (TestQuery, ValueifTRUE)

for the second IIf

I have never seen the first IIf format the you used, so I cannot comment on it.

I have heard of the second IIf format, and I believe it does work, although I have never used it myself