Percent help

[Guest]

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];

 

[Regan via AccessMonster.com]

Hi

What if you divided Delay percent by 10

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

Does that work?

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];

 

[John Spencer]

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
'====================================================

 

[Guest]

Thanks for the help!!! Worked great

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
'====================================================

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];