Sum in Form Footer - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Sum in Form Footer

Walter Hamilton

4 years ago

I'm have a form that is filtered per the guidance in Search Form 2.0

I'm adding calculated fields in the form footer so I can reference them in the main form. This is working for "TotalValue" and "FundedAmount", but everything errors out as soon as I add a field for sum "Invoiced"

"TotalValue" and "FundedAmount" are regular fields bound to a table. Invoiced is a field with the following datasource:

=Format(Nz(DSum("[Amount]","[tbl_Invoices]","[ChargeCode_ID]=" & Nz([ChargeCode_ID],0)),0),"Currency")

Must I do something special to sum a calculated field like this?

	Walter Hamilton OP @Reply 4 years ago
Is there a way to do this in VBA? I always get an error when trying to sum a calculated field. I have multiple search criteria and am building the SQL String in VBA. Can I just add a Sum() clause to the VBA statement?

	Richard Rost @Reply 4 years ago
It's better if the calculated field is in the query that the form is bound to. Otherwise, you really can't do much with it.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View