running sum in query

R

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?
 
M

Michel Walsh

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

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




Vanderghast, Access MVP
 
R

RobD

Thank you! That fixed it!

Michel Walsh said:
The first argument must be a string representation of an expression / field.

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




Vanderghast, Access MVP



RobD said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top