Percentages in Reports

B

BillD

I have posted here after not getting a reply under Reports.
In the detail section of a report I have a text box that has a control
source as "Total Of ID" for a voting Poll. In the footer section I have a
text box with control source "=Sum([Total Of ID])" How can I get a text box
to show a "Total Of ID" in the Detail Section as a percentage Of the Total of
all Records. Ex. "Total Of ID/Sum([Total Of ID])*100"
Any help greatly appreciated.
 
G

Golfinray

If you right click on your text box to get properties, there should be a
Format command that you can set to percent.
 
B

BruceM

I think you almost have it. Try using this as the Control Source of a text
box in the Detail section:
=Total Of ID/Sum([Total Of ID])
Then format the text box as suggested in the other response.
 
B

BillD

That does it. Help greatly appreciated. Thanks

BruceM said:
I think you almost have it. Try using this as the Control Source of a text
box in the Detail section:
=Total Of ID/Sum([Total Of ID])
Then format the text box as suggested in the other response.

BillD said:
I have posted here after not getting a reply under Reports.
In the detail section of a report I have a text box that has a control
source as "Total Of ID" for a voting Poll. In the footer section I have a
text box with control source "=Sum([Total Of ID])" How can I get a text
box
to show a "Total Of ID" in the Detail Section as a percentage Of the Total
of
all Records. Ex. "Total Of ID/Sum([Total Of ID])*100"
Any help greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top