Report Totals

[Guest]

Hi, I am trying to set up a report so that it totals the number entered in to
a field. The field is titled NumberofItems. This field can have any number
in the field (ie, one record will have 3, one may have 10, etc.) I tried
doing =Sum[NumberofItems] but I get an error saying the syntax is incorrect.
Can someone please provide help? Thanks.

 

[Al Camp]

As long as NumberOfItems is a bound field (not calculated on the
report)...
= Sum([NumberOfItems])

 

[Larry Linson]

Hi, I am trying to set up a report so that it totals the number entered in
to
a field. The field is titled NumberofItems. This field can have any
number
in the field (ie, one record will have 3, one may have 10, etc.) I tried
doing =Sum[NumberofItems] but I get an error saying the syntax is
incorrect.
Can someone please provide help? Thanks.

In addition to Al Camp's response, you might be "confusing" Access if the
Control displaying the Field's value has the same name as the field. (Yes,
we know the Wizard creates this, but the Access development team should have
known better.) If the Control is a Text Box and the Field name is "Joe"
then a good name for the Control would be "txtJoe"... look in the Other tab
of the Control's propeties.

Larry Linson
Microsoft Access MVP