Kaup, Chester
Chester_Kaup at kindermorgan.com
Fri May 13 15:18:24 CDT 2005
I am trying to use the DSUM function in the following query to get a
running total of the field1 field. All I get is the total of the field
column on each line of the DSUM. What am I doing wrong or is this the
wrong function?
SELECT Table1.Date1, Table1.Field1, DSum("Field1","Table1") AS [Running
Total]
FROM Table1
GROUP BY Table1.Date1, Table1.Field1
ORDER BY Table1.Date1;
Data
Table1
Date1
Field1
1/1/2204
10
2/1/2004
5
3/1/2004
7
4/1/2004
8
5/1/2004
14
6/1/2004
6