Calculating a total

debora.scrogham · Dec 5, 2005

I have a form that takes a part number from a table and lists all the
different locations it's stored and the quantiy on hand.

How would I create a calculation that would show up in the form footer that
gives me a total of the quantity on hand?

Thanks

Best regards,
[email protected]
[email protected]
http://www.bankarea.com

Arvin Meyer [MVP] · Dec 5, 2005

Add a textbox to the footer and set its controlsource to:

=Sum([FieldName])

If the form is a subform, set the height of the textbox and the footer
section to 0, and add another textbox on the main form which will have a
controlsource of:

=[Forms]![FormName]![SubformControlName].Form![Footer Textbox Name]
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Calculating a total

debora.scrogham

Arvin Meyer [MVP]