## Percent help

### Percent help

Hello I have a query that I want to divide the employees delay time by the
employees worked time. I made this query which works but the decimal place is
in the wrong spot. I am looking for a percentage like this 35% but its giving
me 353% I have the query "Delay Percent: Sum([DT REGULAR]/[EMPLOYEE TIME])"
fomat set at percent and I have the text box on my report set at "decimal
place 0 format percent". What am I doing wrong? Here is the SQL code:

SELECT Sum([DT REGULAR]/[EMPLOYEE TIME]) AS [Delay Percent],
tblMain.[EMPLOYEE NAME]
FROM tblMain
WHERE (((tblMain.[EMPLOYEE NAME])=[ENTER EMPLOYEES NAME]) AND
((tblMain.[DAYS DATE]) Between [Enter Start Date: (mm/dd/yy)] And [Enter Stop
Date: (mm/dd/yy)]))
GROUP BY tblMain.[EMPLOYEE NAME];

### Percent help

Hi

What if you divided Delay percent by 10

Sum([DT REGULAR]/[EMPLOYEE TIME])/10 AS Delay Percent,

Does that work?

--
Regan,
Paeroa
World famous in New Zealand

Message posted via http://www.yqcomputer.com/

### Percent help

Try dividing

Sum([DT REGULAR]) / Sum([EMPLOYEE TIME]) as DelayPercent

So if employee A had .3 on day 1 and .5 you ended on day 2 up with .8
for the two days.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

### Percent help

Thanks for the help!!! Worked great