Tabulate a Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I add up the values in a column in a form and a
table. The sample database did it but I can't see where
they added it up.
 
How do I add up the values in a column in a form and a
table. The sample database did it but I can't see where
they added it up.
Click to expand...

You cannot add in a Table; tables are for data storage, not for
calculations.

You can create a Totals query based on your table and calculate a
total there, optionally Grouped By some other field or fields.

On a Form or a Report you can put a textbox in the Form (Report)
Footer with a control source property of

=Sum([fieldname])

to display a total.
 
Back
Top