Re: How to Create Employee's Monthly Production Report in MS Access Version: 2007
In my db I have 2 tables called log and production.
In log table i have created login time, logout, holidaylist. etc. (UserID is Primay Key)
In production table Stime, Etime, task and remarks fields are there (Userid is foreign key). What i want is, once they login to the db, (lob table will update), should enter production details (based on production table) of day (hourly).
Today if they worked 8 hours
STime ETime TotalHours Task
9 am 1 pm 4 aaaaa
2 pm 6 pm 4 xxxxxx
If they have not login means it read the log table (Holidaylist filed and if is matching with holdiay date then should take has holiday else next day it should give a pop message like yesterday you have not login, please update the form (reason they should give otherthan holiday)
Hope this is will give you a clear picture about my db.
Thanks and Regards,