Hi -
I am trying to generate footer totals and having issues. In the header I have an iif statement which generates 2 lines for an individual:
Header:
iif(Answer like 'y',Yes,No)
D Smith
'Yes' 1 1 1
'No' 2 3 4
B Smith
'Yes' 1 1 1
'No' 2 3 4
Footer Totals
Totals 7 8 10
I need to be able to total the Yes and No separately..........can this be done?
Thanks.