Percent help

Percent help

Post by Q2hhZ » Thu, 17 May 2007 07:04:01


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

Post by Regan via » Thu, 17 May 2007 07:22:47

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

Post by John Spenc » Thu, 17 May 2007 08:19:27

Try dividing

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

Your formula was adding the calculated percentage for each day together.
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

Post by Q2hhZ » Thu, 17 May 2007 08:45:01

Thanks for the help!!! Worked great