Summing up a column

S

Scott

I have a table that has items and how much they sold for.

table 10.00
chair 5.00
bought table -5.00

I want to add all these up and show in a separate column
or at the bottom of the column that has the pricing.

The total would show $10.00

I tried the sum function but it didnt seem to work.

Any help would be great
Thanks
Scott
 
M

Michel Walsh

Hi,



DSum("fieldName", "TableName")

should do. You can assign it as control source, in this case precede the
expression with the = sign.



Note that the field name, or expression, should be between quotes.



Hoping it may help,
Vanderghast, Access MVP
 
D

Duane Hookom

What do you mean by "didnt seem to work"? What expression did you use for
the sum and where did you place the sum. Make sure you didn't try this in a
PAGE FOOTER section.
 
Top