What is the database engine on which this query will be runned?
Access recognize IIF but SQL Server needs a CASE.
>Is it possible for me to insert IIF function in SQL Statement.. for example:
>
>SELECT MONTHLYSALES.*, IIF(MONTHLYSALES.POINT gt=10, "Good", IIF(MONTHLYSALES.POINT gt=5 AND MONTHLYSALES.POINT lt 10, "Enough", "Bad")) as SALESPOINT FROM MONTHLYSALES ORDER BY SALESMANCODE
>
>(pls correct the above SQL statement if there's mistake)
>
>any idea would be greatly appreciated and many thanks in advance
>
>Regards
>Winan
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com