Error on Named Calculation

When I creat a Named Calculation with the following code:

case

when [Sales]<1000 then 'Below'

when [Sales]<2000 then 'O.K.'

when [Sales]>=2000 then 'Good'

else 'None'

end

I get error on save:

IErrorInfo.GetDescription failed with E_FAIL(0x80004005).

Thanks.

Joe.

What database are you connecting to? SQL Server? Access? If you are using Access, it doesn't support CASE - you would have to use IIF|||Thanks Jamie. You are right. I am using Access.sql