|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 14th, 2007, 10:15 PM
posted to microsoft.public.access.queries
|
|||
|
|||
need help with percent
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!!! 
|
|
#2
February 14th, 2007, 10:57 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
need help with percent
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" wrote: 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!!!
|
|
#3
February 14th, 2007, 10:57 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
need help with percent
hi,
try: format(x, "#,##0") DelayPercent: format(([RegularDelay]/([Employee Regular Time]), "#,##0")) "oxicottin" wrote: 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!!!
|
|
#4
February 14th, 2007, 11:47 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
need help with percent
Geebee, Im getting a Syntax Error (Comma) in query Expression DelayPercent:
format(([RegularDelay]/([Employee Regular Time]), "#,##0")) "geebee" wrote: hi, try: format(x, "#,##0") DelayPercent: format(([RegularDelay]/([Employee Regular Time]), "#,##0")) "oxicottin" wrote: 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!!!
|
|
#5
February 15th, 2007, 12:14 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
need help with percent
Worked great James!! Thanks for the help....
"JamesDeckert" wrote: 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" wrote: 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!!!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
