Hi All
I have the following SQL statement that will not execute.
Can i get someones take on this.
Thanks
I have the following SQL statement that will not execute.
Can i get someones take on this.
Code:
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