need help with percent

[Guest]

I have a qry where I want to divide "Regular Delay" by "Employee Regular
Time" and give me a percent. Example:

Regular Delay 2.5hrs
Employee Regular Time 8.0

=31%

I am using this in my Field.
DelayPercent: ([RegularDelay]/([Employee Regular Time]))

is there any way to show it as 31% on my Report with no decimals?

Thanks!!!

 

[Guest]

When in design mode of your report, right-click the percent field and go into
properties.

Format allows you to format for %
Decimal Places allows a specific number to the right of the decimal.

James

 

[Guest]

hi,

try:
format(x, "#,##0")
DelayPercent: format(([RegularDelay]/([Employee Regular Time]), "#,##0"))

 

[Guest]

Geebee, Im getting a Syntax Error (Comma) in query Expression DelayPercent:
format(([RegularDelay]/([Employee Regular Time]), "#,##0"))

hi,

try:
format(x, "#,##0")
DelayPercent: format(([RegularDelay]/([Employee Regular Time]), "#,##0"))

I have a qry where I want to divide "Regular Delay" by "Employee Regular
Time" and give me a percent. Example:

Regular Delay 2.5hrs
Employee Regular Time 8.0

=31%

I am using this in my Field.
DelayPercent: ([RegularDelay]/([Employee Regular Time]))

is there any way to show it as 31% on my Report with no decimals?

Thanks!!!

 

[Guest]

Worked great James!! Thanks for the help....

When in design mode of your report, right-click the percent field and go into
properties.

Format allows you to format for %
Decimal Places allows a specific number to the right of the decimal.

James

I have a qry where I want to divide "Regular Delay" by "Employee Regular
Time" and give me a percent. Example:

Regular Delay 2.5hrs
Employee Regular Time 8.0

=31%

I am using this in my Field.
DelayPercent: ([RegularDelay]/([Employee Regular Time]))

is there any way to show it as 31% on my Report with no decimals?

Thanks!!!