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

 

[Joseph Meehan]

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

I assume that all those different locations are separate records.

I suggest that you base the form on a query and use the query to provide
the total. I would guess there are several other ways as well. I used a
separate query to provide the first query with the sum. I suspect there is
an easier way.