sum on the report

[fanfan2]

I used the wizard to generate a report based on a query.
In the report, under the detail, I changed the txt box name to txtField. then I created a text box under report footer to sum the values from the field in the details. On the control source, I typed:
=Sum([Field]). (the Field is the name appeared on the drop down list of the control source). then I got the "Error". I also tried on the control source to type in =sum([qryName]![field]). still didn't work.

Any help will be much appreciated.

 

[statsman]

Just a quick idea:
Do you have the field you are summing on in the detail section? If not, you are asking the sum to add up a field that isn't there.
If this is the case, add a text box with the required field into the detail section and set the property to visible=no.

 

[fanfan2]

yes I have the field in the detail section and it shows well on the report.