[AccessD] DSUM Function - HELP

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

 




More information about the AccessD mailing list