Percentages in Reports

[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.

 

[Golfinray]

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

 

[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.

 

[BillD]

That does it. Help greatly appreciated. Thanks

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.

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.