"sebastienm" wrote ...

replace the Case statement by an IIF statement, eg:
SELECT
ActualApr05,
iif( ActualApr05 <0, ActualApr05, 0) as QT105
FROM forecastcosts

I can't see the CASE statement is needed e.g. apart from being less
efficient, how is it different from

SELECT
ActualApr05, ActualApr05 AS QT105
FROM forecastcosts

?

Jamie.

--