Doing Percentage on a report

[darkhat01]

I am trying to do percentages on my report in the expression builder, here is what I did:

=Round((([text67]/[text60])*100),0) & "%"

It does work, but does not look pretty. Is there a better way to do percentages?

Thanks,
Darkhat01

 

[dhookom]

I rarely if ever provide formatting in the control source. Try set the format property to "Percent", Decimal Places to 0, and Control Source to:
= [text67]/[text60]

Then consider going back and renaming text67 and text60 to appropriate values so your application is self-documented.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[darkhat01]

Thanks bhookom

 

[dhookom]

You're welcome barkhat01 ;-)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]