Hi.
I'll assume that the first textbox is name "CountAll" and
the second is "CountYes", and that these two texboxes are
in the report footer.
Than you can create a third textbox and you can set the
control source to
=[CountYes]/[CountAll]
Set the format for this textbox to percent and it will do
just what you want.
Hope this helps.
Fons
-----Original Message-----
I have these captions on the Report footer First Text
Box: =Count([Y/N]) gives me a total of "Y/N" Second text
box:=Abs(Sum([Y/N]="N")) gives me a total of only "N" Here
is the questions, how can I divide "N" by "Y/N" to get a
percentage?I used a text box with =Sum([Y/N]="N")/([Y/N]),
but it doesn't work. Any help, thanks!
