Help with running sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I browsed previously posted messages here, but for some reasons, I can't seem
to be able to make my subquery work ...

pID Total u_time date type
139 14 15:41 20050208 G
140 20 14:00 20050131 B
141 11 15:55 20050208 G

I need a fifth colum with the running sum of "Total".

In the subquery, I can't use "<pID" to define the sum since old entries were
not entered in order. I guess I'll need to use "< date OR (=date AND <
u_time)".

Any suggestions ??
Thanks.
 
If you can't use pID then you can use a combination of the date and time.
Work on it. If you still have questions, come back with the data types of
your fields.
 
Back
Top