Urgent Help needed....

[arifmasum]

Dear Readers,

Please help me. I am stuck here. I need to get holiday, and leave in employee attendance report. But I can not understand how i can do it. I am attaching employeedate database. Please help me.

Thanks with best regards.

Arif Masum

 

[twoplustwo]

Is tblAttendance a record of when they start each day?

Also, look at renaming your columns to something like Att_Date / Att_Time or something.

 

[arifmasum]

More questions

Yes, the tblAttendance table is created by importing card reader machine data ( fixed length ). It contains both InTime and OutTime for each day.

I need to insert Holidays like 04/13/2007 (according to the test data attached) is a holiday in my country Bangladesh. In the Attendance report I need to show that date mentioning it's a holiday. But I wonder what method i should apply to get that value.

Thanks a lot for your answer and advice regarding field naming. I am doing that. Best wishes to you and your family.

Arif Masum

 

[arifmasum]

Sorry I forgot to say I have made that attendance table in date and time format. I am able to calculate work time regularly. Hope to hear from you soon. thanks

 

[Darth Vodka]

Dear Readers,

Please help me. I am stuck here. I need to get holiday

i hear the south of France is lovely

 

[twoplustwo]

So you need to denote PUBLIC holidays, yes?

 

[arifmasum]

Yes, I need to denote public holidays, then I need to allocate leave for employees. I need to complete the task soon. So many need (lol), but you dont worry. Please help me with some ideas. thanks a lot....