Attendance Calculation

[syedadnan]

Regards,

I have a db attached with three tables;
1 tblemployee is recording of employee
2 table roasters where i am recording weekly roasters for employee
3 data_from_time_machine is a table because i have a time machine installed but the software do not support me to my choice hence making my own through this practice. i fetch data from software in excel format and copy into the 3rd table the time/date field in excel data is general with date and time now i want minimum time for a specific date to be as time-in and maximum time as time-out, 15 minutes late to the shift assigned as per roaster table will be as late. here one thing to be noted that the excel data only comes for the data for which the employee marked attendance but i want whole date in a month to be showed example like if in the month of march the data to be showed from 1st till 31st march with status of time in and out and absent for no shows.

 

[arnelgp]

open query qryTimeSheetWithParameter.

 

[syedadnan]

open query qryTimeSheetWithParameter.

WOW !! I checked that absouletly as per my request ..

Great work done... thanks a billion .....

 

[syedadnan]

open query qryTimeSheetWithParameter.

Dear Arnelgp,

Now in for second project, it was fine for the first choice but now in qrytimesheetparameter i just want the query to be open with date range like;

one message box for start date then second for end date, this what i want in my second case ... hope you will do this..
also please let me know that iam having 600 employees so is the query will work ok after having 600 employees 30 days then yearly data ? or it will slow ahead ?

 

[npatel]

Thank You....