I have one field in my query that pulls the time diff. In Start and End time.
My issue is getting the time to divide by the amount of parts. To see how long it takes per part.
What I have tried so far.
PerPart: Format([Start]/[TimeDiff],"Short Time")
But the result just shows a #Error..
Thinking this might help.
Any help would be great.
Thanks.
My issue is getting the time to divide by the amount of parts. To see how long it takes per part.
What I have tried so far.
PerPart: Format([Start]/[TimeDiff],"Short Time")
But the result just shows a #Error..
Thinking this might help.
Code:
SELECT tblFinishing.EmployeeNumber, tblFinishing.ReJobNumber, tblFinishing.ReOperationNumber, tblFinishing.ReSubCode, tblFinishing.StartTime, tblFinishing.Start, tblFinishing.Good, tblFinishing.Scrap, tblFinishing.EndTime, Format([StartTime]-1-[EndTime],"Short Time") AS TimeDiff, Format([Start]/[TimeDiff],"Short Time") AS PerPart
FROM tblFinishing
GROUP BY tblFinishing.EmployeeNumber, tblFinishing.ReJobNumber, tblFinishing.ReOperationNumber, tblFinishing.ReSubCode, tblFinishing.StartTime, tblFinishing.Start, tblFinishing.Good, tblFinishing.Scrap, tblFinishing.EndTime
HAVING (((tblFinishing.ReJobNumber) Like "*" & [Enter Job Number] & "*") AND ((tblFinishing.Start) Is Not Null))
ORDER BY tblFinishing.ReSubCode;
Any help would be great.
Thanks.
Last edited: