"I need to create an expression in my query that will keep a running total of another column."

> Week       DataValue   	    Exp01
> 01/03/99        3             3
> 01/10/99        4             7
> 01/17/99        3            10

It's much better to do that in a report, but here goes. . .

Exp01: CDbl(DSum("Nz([DataValue])","TheQuery","Week <=#" & [Week] & "#"))

It will be quite slow. . .