need help with percent

O

oxicottin

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!!!
 
J

JamesDeckert

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
 
G

geebee

hi,

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

oxicottin

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

geebee said:
hi,

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




oxicottin said:
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!!!
Click to expand...
Click to expand...
 
O

oxicottin

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

JamesDeckert said:
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

oxicottin said:
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!!!
Click to expand...
Click to expand...
 
Top