[AccessD] SQL Running Sum - 2

Is this an Access totals query?  Otherwise, turn on the totals row to make Sum a usable function.  Are you after a running sum or a total?  Perhaps if you explain how you want to use the value, it will be easier to get an answer.

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 1:12 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com