Totaling up a column of numbers

I used to be able to create an expression to total numbers in a column to
appear in a second column I don't remember how I did it but I can still do it
in MS Works, not that it helps me with access. The best I can do is copy the
values in the first column into the second, or add horizontally, not what I
want to do. I want to add the numbers in a field, not the record

You can add a text box to a report or group footer and set its control source
to something like:
=Sum([YourNumericFieldName])

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


"ArthurRW" wrote:

I used to be able to create an expression to total numbers in a column to
appear in a second column I don't remember how I did it but I can still do it
in MS Works, not that it helps me with access. The best I can do is copy the
values in the first column into the second, or add horizontally, not what I
want to do. I want to add the numbers in a field, not the record