Calculating a total

[debora.scrogham]

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,
(e-mail address removed)
(e-mail address removed)
http://www.bankarea.com

 

[Arvin Meyer [MVP]]

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