running sum in query

[RobD]

I am struggling with a DSum calculation...this is what I am asking for:

total time in minutes: DSum([time in minutes],"schedule report new","order
<= " & [order] & "")

and this is the output that I am getting:
order time in minutes total time in minutes
1 34.95 34.95
2 34.95 69.9
3 34.95 104.85
4 34.95 139.8
5 46.6 233 (which is 46.6 * 5)
6 34.95 209.7 (which is 34.95 * 6)
7 34.95 244.65 (which is 34.95 * 7)
8 15.7275 125.82 (which is 15.7275 * 8)

I have tried to do a two step query (get the base data first, then run the
DSum), but that didn't help either. Any clues?

 

[Michel Walsh]

The first argument must be a string representation of an expression / field.

DSum( "[time in minutes]", ... )




Vanderghast, Access MVP

 

[RobD]

Thank you! That fixed it!

The first argument must be a string representation of an expression / field.

DSum( "[time in minutes]", ... )




Vanderghast, Access MVP

I am struggling with a DSum calculation...this is what I am asking for:

total time in minutes: DSum([time in minutes],"schedule report new","order
<= " & [order] & "")

and this is the output that I am getting:
order time in minutes total time in minutes
1 34.95 34.95
2 34.95 69.9
3 34.95 104.85
4 34.95 139.8
5 46.6 233 (which is 46.6 * 5)
6 34.95 209.7 (which is 34.95 * 6)
7 34.95 244.65 (which is 34.95 * 7)
8 15.7275 125.82 (which is 15.7275 * 8)

I have tried to do a two step query (get the base data first, then run the
DSum), but that didn't help either. Any clues?