[AccessD] SQL Running Sum - 2

Eoin C. Bairéad ebairead at gmail.com
Thu Dec 13 12:12:55 CST 2007


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



More information about the AccessD mailing list