total time calculation for overtime

[mathanraj76]

Hi..



I have problem in last part of my reports..
I have create overtime database for the staff

I have start time and end time

so after this "end time - start time" i will get how hours and minutes does a staff do overtime

this report will generate from 1st to 30th ..

at the end i need to call calculate total hours and minutes does a staff do overtime on a month..

Can some show me the way how to call total hours and minutes in my access report

Thanks

[ranman256]

on a form,frmRpts, put text boxes for start and end dates, txtStartDate, txtEndDate

Q1. make a query to sum the Total hrs /person per week. (fractional hrs too)
Q2, using Q1 split the Reg Time and Overtime. (unless you've already done it in fields)

you can also write these weeks to a temp table to sum later

sum for the month. All queries should use date ranges from the form (weekly, and monthly)
select * from table where [date] between forms!frmRpts!txtStartDate and forms!frmRpts!txtEndDate