Suyog,
If you have the design ogf your data share it please.
my idea is like this...
1)A master file for employees
2)A transaction file for in and outwhich contain transactioncode,date,trntype(in/out),time,employeecode&name.
By validating data while input we can get
a uniform type of data.
from that we can generate reports.
from trntype we can also get the present status of the employee...
This is only a vague idea.But can be put into
practice without so many complications I think.
regards
-Sudheer