calculating percent of totals

[Guest]

USing Access 2000. Lgical field in table named "TrxRegistered" Use dteh
report wizard to create a summary report showing number of participants for a
series of sessions.
Thanks to D Hookum for his post earlier about the immediate IF to sum the
number of positive respones recorded in the field, that helped me also!
The wizard set a calculation of "=Sum([TrxRegistered])/([TrxRegistered Grand
Total Count])". This does NOT calculate to any accurate number.
I have replaced the original wizard calculation for the grand total with teh
following-- =Sum(IIf([TrxRegistered]=True,1,0)).
Formulas to calculate percentage tried thus far include:
=Sum([TrxRegistered])/([TrxRegistered Grand Total Count])
=Count([TrxRegister])/([TrxRegistered Grand Total Count])
Neither of these return vialble results.

"TrxRegistered Grand Total Count" is the name of the text box object storing
the total number sessions.

Can anyone point me in the right direction to calculate the individual
percent of totals for each session?

Thanks for any help you might offer

 

[Guest]

Finally discovered the root of my problem. Turns out teh formulas were just
fine. I was unaware that the result might displayed with a minus sign(-) in
front to indoicate that the field LENGTH on the report was not large enough
to properly display the result.

Was definitely a learning experience, but a costly one in time.