- Joined
- Aug 12, 2008
- Messages
- 1
- Reaction score
- 0
Hello everyone. I'm hoping someone can help me with this.
I have a table with the following fields: Job Number, Date, Amount
Here's what we are trying to do. In a query, have it group by Job Number and then Date, and then sum the Amount. But instead of having just a sum by that date, we want it to have a running sum that calculates the sum from that date and adds it to the sum of all the previous dates (but just by that job; it should restart when the next job number is reached). Any way to do this in the query? Or will we have to result to some code on the form? Either way, help would be greatly appreciated.
Thanks a lot,
Tim
I have a table with the following fields: Job Number, Date, Amount
Here's what we are trying to do. In a query, have it group by Job Number and then Date, and then sum the Amount. But instead of having just a sum by that date, we want it to have a running sum that calculates the sum from that date and adds it to the sum of all the previous dates (but just by that job; it should restart when the next job number is reached). Any way to do this in the query? Or will we have to result to some code on the form? Either way, help would be greatly appreciated.
Thanks a lot,
Tim