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