[AccessD] SQL Running Sum - 2

Where are you trying to do this, in a form, report, or query?

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Eoin C. Bairéad
Sent: Thursday, December 13, 2007 10:13 AM
To: Access Developers discussion and problem solving
Subject: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com