Steve Erbach
erbachs at gmail.com
Fri May 13 16:45:05 CDT 2005
Chester, This might help you: http://support.microsoft.com/default.aspx?scid=kb;en-us;290136 Steve Erbach On 5/13/05, Kaup, Chester <Chester_Kaup at kindermorgan.com> wrote: > 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]