criteria in running sum formula

[stan]

This running sum formula works fine with a query:

RunTotal: Format(DSum("[LoanAmount]","[Banking]","[Record Number]<=" &
[Record Number] & ""),"$0,000.00")

I'm unclear where to Add criteria so it only runs a running total for a
particular Department--in this case "Bookkeeping"

No matter where I insert the criteria in the formula it shuts it down. what
am I doing wrong?

 

[Duane Hookom]

If the department is hard-coded, use something like:

RunTotal: Format(DSum("[LoanAmount]","[Banking]","[Record Number]<=" &
[Record Number] & " AND Department='Bookkeeping'"),"$0,000.00")

Also, I rarely if ever perform any formatting in the query. Save this for
assignment in the controls on forms and reports.