var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Counting in a report
I have a question, probably very simple but I have spent the last few hours trying to work this out but I can't seem to get it.
I have three fields (datatype is number - i used number as I wish to have null values in some cases):
I have these set up as Yes and No option groups (Yes = 1, No = 2).
What I want to do is total all of the individual calls made in a report, ie
CallAttemptOne - yes = xx, no =xx
CallAttemptTwo - yes = xx, no =xx
CallAttemptThree - yes = xx, no =xx
I would also like to have total number of calls made overall.
So far I have tried:
Everything I try ends up getting #error
Where I am going wrong / what am I not doing? Am I even on the right track?
Thanks for taking the time to read this.
=Sum(IIf([CallAttemptOne]=1, 1, 0))
It does work, however it only works in the detail section of the report. If i put it in the page footer i get the error and thats where i need the count to be.
That will work in a group or report footer. Getting it in a page footer is trickier:
Summing in reports - Access - Office.com
about half way down.
Actually, im an idoit. Report footer is what i want.
Thanks very much pbaldy.