Forum Discussion
Newby trying to total all the Yes's
HI. I am not an Access user and know very little about it. I do use one Access 2007 database as one part of my job. I now need to create a report from it. I have figured out how to make the repor...
Hi,
Insert a new text box in the section where you want to see the sum (e.g. in the report footer) and use this expression in the property ControlSource of the text box:
=Abs(Sum([Approval]))
In Access Yes is saved as -1, No = 0. Therefore the expression just sums up the values and makes the sum positive with the Abs() function.
Servus
Karl
****************
Access Bug Trackers
Access News
Access DevCon
