Running Total using a Query

  • Thread starter Thread starter DenaK
  • Start date Start date
D

DenaK

I am trying to create a running total of charges to a person's account in a
query. I have been able to get the running total to work but it only does
the running total for one month and then starts over, while I need the total
to keep going month to month and year to year.

I have this in the field line with "Total" set to "expression":

RunTot: DSum("[Curr Dedn]","GarnAmountsTable2","DatePart('d',[Check Dt])<="
& [ADay] & " And DatePart('m', [Check Dt])<=" & [AMonth] & " And
DatePart('yyyy', [Check Dt])<=" & [AYear] & "")

I appreciate any thoughts.

Dena
 
Use a query to get the raw data.

Use a report to do the monthly roll-ups.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Some fill canvas the stock of SEC's content recommendations to an Oct. 2, 2006, diary install by Sun Microsystems CEO, Jonathan Schwartz e_small_step_for_the), in which he complained that, "I couldn't use my blog to lineage 2 adena[/url:2jl63nyy]declare our quarterly action, or unveil a touchable dealing. I had to use a machine channelise, or a c (http://www.ugamegold.com/c_Lineage2-Adena/:2jl63nyy)nce meet
 
Back
Top