Percentage in a Report

[CoachPhil]

I am trying to relate a calulated amount in a report as a percentage. How possible is this from a text box in a report?

CoachPhil

 

[statsman]

As you are "Coach" Phil I assume this has to do with sport.

Personally, I would calculate this in the query that runs the report.

Create a new field in the query tittled "PCT"
PCT: ([gameswon]/[gamesplayed])
In the report you can set the properties to Percent.

 

[ajetrumpet]

if the textbox is bound to an expression or something, maybe change the "format" property of the data. if it is not, issue code behind the report when it is opened to get what you need...

me.textbox = me.textbox = [B]some calculation to get a percentage[/B]

 

[CoachPhil]

Thanks Gents,

I got one and am working on the others.

CoachPhil(football)