[AccessD] Help needed with DSum

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Oct 25 15:21:42 CDT 2005


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.

 




More information about the AccessD mailing list