Sum checkbox shows negative

[rchhvol]

I've read several posts about summing checkboxes as positive numbers but none of the solutions seem to work for what I am doing. I have a query that sums 4 different checkboxes, grouped by Year. This query sums Yes values correctly and displays negative numbers, as expected.

nbrYear Group by
ysnSpring Sum resulting field name SumOfysnSpring
ysnSummer Sum resulting field name SumOfysnSummer
ysnFall Sum resulting field name SumOfysnFall
ysnWinter Sum resulting field name SumOfysnWinter

Here is my question: How can I display the aggregate function fields [SumOfysnSpring], etc. as positive values in a report based upon the query?

I've tried =abs([SumOfysnSpring], =([SumOfysnSpring]*-1) but I get an error (#error). I am assuming the error is based on the fact that the fields are summary fields. Thanks in advance for your help.

 

[Rich]

Did you change the name of the textbox from that given by the Wizard ?

 

[rchhvol]

No, I didn't change the name that was assigned by the wizard in the query.

 

[Rich]

You should when using calculated controls on a report, Access gets confused

 

[rchhvol]

Where do you change the name of the calculated control? In the properties of the control on the report? I'm not quite following. Sorry!

 

[Rich]

Open the property sheet for the report, click on the the control in question, click on the "other" tab on the property sheet, change the name to say txtSumOfysnSpring or whatever is meaningful