criteria in running sum formula

  • Thread starter Thread starter stan
  • Start date Start date
S

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?
 
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.
 
Back
Top