Column Sum

K

Kris

Hi,

I am fairly inexprienced with Access, and am trying to calculate one column
on my report. I have created the text box, and put "=Sum([#BUNCHES])", as
help has told me to, however, on the report I get "Error", instead of the
total. What am I doing wrong?
 
M

Marshall Barton

Kris said:
I am fairly inexprienced with Access, and am trying to calculate one column
on my report. I have created the text box, and put "=Sum([#BUNCHES])", as
help has told me to, however, on the report I get "Error", instead of the
total. What am I doing wrong?
Click to expand...


Double check to make sure that [#BUNCHES] is the name of a
**field** in the report's record source table/query, not the
name of a control on the report.
 
Top