Calculating option group value in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I have a question. In my database I have an option group (gender) and I
want to calculate the total for each of them separetedly, like 10 students, 3
males and 7 females, in my report. All I can get is the total for both
together. Appreciate your kindness..
Odir
 
Hi. I have a question. In my database I have an option group (gender) and I
want to calculate the total for each of them separetedly, like 10 students, 3
males and 7 females, in my report. All I can get is the total for both
together. Appreciate your kindness..
Odir
Click to expand...

Add an unbound control to the Report Footer.
Set it's control source to:
What Option value is Male? Let's assume it's 1.
=Sum(IIf([OptionGroupName]=1,1,0))

What Option Value is Female? Let's assume 2.
=Sum(IIf([OptionGroupName]=2,1,0))
 
Back
Top