[AccessD] Help needed with DSum

Sorry to report all I get is a sum for each day not a running total.
Maybe I did not make it clear.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Conklin
Sent: Tuesday, October 25, 2005 3:42 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Help needed with DSum

Try:

SELECT Injection.RecordDate, DSum("[Theoretical CO2] + [Theoretical
Water]","Injection","[RecordDate]=#" & date() & "#") AS [Cum Inj]
FROM Injection
GROUP BY Injection.RecordDate;

' changed RecordDate to date()


Steve


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Tuesday, October 25, 2005 4:22 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Help needed with DSum

I have the following query to try to get a running sum with a sum each
day.
I am getting the same number each day. I probably have some simple
syntax
error but am not seeing it. Her eis the SQL.

SELECT Injection.RecordDate, DSum("[Theoretical CO2] + [Theoretical
Water]","Injection","[RecordDate]=#" & [RecordDate] & "#") AS [Cum Inj]

FROM Injection

GROUP BY Injection.RecordDate;

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number
of electrons were terribly inconvenienced.

 

--
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