Need to get a Percent

[Livinit]

I have a yes and no column 1=yes , 2=no.
I want to get the percent of the yes's among the group as apposed to the no's

 

[Blorf]

I assume in your report you want it at the report footer. So, make a text box, and set the control sourcse to be either -

=Sum(IIf([Field]=1,1,0)) (Counts the 1's)

Or

=Sum(IIf([Field]=2,1,0)) (Counts the 2's)

Where field is your field name.


ChaZ




Ascii dumb question, get a dumb Ansi