summing daily time for timecard reporting

[b_c]

hello all

currently have the report above based on a query and a "where" statement in an openreport macro...

...here's my dilema. the report works fine and groups/sorts how i want it to, the problem arises when i want to capture the daily hours worked by the employee?

my clocklogtable is built so that each line gets a transidnum, empid, clocktranstype (clockin, lunchout, lunchin, clockout), date, and time.

so for one day an employee will have 4 separate lines in the clocklogtable...with different transid's, times, and clocktranstypes. how do i take these 4 times and come out with an aggregate daily hours worked for the employee, for the day?


i'm stuck like chuck...


cheers,

b_c

 

[b_c]

see above for output of report as it exists and what i want to show...anyone know how to sum daily hrs worked?



b_c

 

[b_c]

anyone? ...this is kicking my @ss. it's gotta be simple, that's why i'm not doing it.


b_c

 

[b_c]

anyone? ...this is kicking my @ss. it's gotta be simple, that's why i'm not doing it.


b_c

anyone ever read "access 2007 vba" ... will that help me? i'm reading chapter 11, right now. i'm hoping theres something i'm missing.

...i'd still like to hear anyone's input on this. bueler...bueler...bueler.



b_c