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