How do I calculate a ratio in a report?

[Snugent]

I have used report wizard to create a report which groups by the value in my field (titled Own/Rent). This part worked fine. It gives me the count for each value (Own, Rent). Now I need to calculate the ratio between Own and Rent and I can not figure out how to get Access to do it. Please help!

[June7]

Do you have Count() calcs in report and/or group footer?

What is your ratio formula?

[Snugent]

I do have a count in my group footer.

My formula for calculating the ratio is the (count of Own/Rent=Own) divided by the (count of Own/Rent=Rent)

[June7]

Okay, try:

=[textboxname for Own] / [textboxname for Rent]

[Snugent]

Thank you!