Running sum by contract nbr and Date

  • Thread starter Thread starter Chad Landry
  • Start date Start date
C

Chad Landry

I have a table with the following fields:

Contract_nbr
Draw_date
Draw_Amt

What I'd like is to have a running sum of the Draw_Amt by Date for each
contract_nbr. In other words I don't want the running sum to be cumulative
for the entire table but start afresh with each new contract nbr. I've tried
using Dsum, but I haven't had any luck.

basically I'm trying to find a point in time when a contract reached an
amount drawn.

Any help would be appreciated!



Any help would be appreciated.
 
One approach might be to use a query to return the values, but use a report
based on that query to generate the "running sums".

I believe you can add a textbox control on your report in design mode, and
set its Running Sum property.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top