dsum or not

tubar

Registered User.
Local time
Today, 13:27
Joined
Jul 13, 2006
Messages
190
In my query im using dsum to accumulate hours worked for a shift.If the employee has three entries in one day and during entry 2 goes into overtime(accumulated over 8 hours) dsum isn’t helping me
Code:
run: DSum("[event regular hours]","[tblbuild]","[tblbuild]![stagehand] = " & [tblbuild]![stagehand] & " AND [tblbuild]![day of event] <=#" & [tblbuild]![day of event] & "#")
can some one point me in the right direction
 
a better explanation...
im attempting to get this....
DATE: 3/2/13
TOTAL HOUR:7
REG HOUR:7
OT HOUR:0
RUN HOUR:14.5
EMPLOYEEgreg

DATE: 3/2/13
TOTAL HOUR:7.5
REG HOUR:1
OT HOUR:6.5
RUN HOUR:14.5
EMPLOYEEgreg

But all I get is this....
DATE: 3/2/13
TOTAL HOUR:7
REG HOUR:8
OT HOUR:6.5
RUN HOUR:14.5
EMPLOYEEgreg

DATE: 3/2/13
TOTAL HOUR:7.5
REG HOUR:8
OT HOUR:6.5
RUN HOUR:14.5
EMPLOYEEgreg
 

Users who are viewing this thread

Back
Top Bottom