Running Total using a Query

[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

 

[Jeff Boyce]

Use a query to get the raw data.

Use a report to do the monthly roll-ups.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[WhiteCreation]

To do it enter <ifADD1-2=3>

1= value
2= value
3= filed name

 

[noreply@noreply]

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