[AccessD] SQL Running Sum - 2

in a query

On 13/12/2007, Charlotte Foust <cfoust at infostatsystems.com> wrote:
>
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



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