Your current query should work in Access.

In SQL, it will looks like this:

SELECT MONTHLYSALES.*, 
case MONTHLYSALES.POINT>=10 then "Good" else
   case MONTHLYSALES.POINT >=5 AND MONTHLYSALES.POINT<10 then "Enough" else "Bad" end end as SALESPOINT FROM MONTHLYSALES ORDER BY SALESMANCODE

>Could you please give me an example .. for Ms. Access and also if I use Ms. SQL .. many thanks in advance
>
>Regards
>Winan