[AccessD] SQL Running Sum - 2

hi

I see nothing in the SQL book to tell me that the following is impossible,
but it won't compile.

Sum(IIf(W.ClientID >0, W.WorkHours,0)) AS ClientHours,

is there a problem with a conditional running sum.

Eoin
-- 
-- 
Eoin C. Bairéad
Dublin, Ireland
Áth Cliath, Éire