Nepalover, The CASE WHEN seems to be for SQL server, for Access use the Switch statement like following: SELECT fruit, N, Switch( fruit='apple',N*2, fruit='orange',N/3 ) AS calculatedcolumn FROM yourtable; you can use multiple fruit = 'xxx', and calculations on the above statement to get your result