hello am attaching time sheet ( microsoft access) example
problem with it- if employee comes into work and clocks out for doctor appt. and clocks back in before lunch- this program has does not allow that.
you will open database and see a form.
on form you have 4 buttons- to clock in- go to lunch- return- and leave
you will see the tbl1 - data comes in different records and I have to run qry1 to put all data in same record
can you come up with better way to do this?
and compensate for people who might leave between morning and lunch or lunch and leaving?
is there way to just have a clock in and clock out and behind the scenes - it collects data correctly
must be done in microsoft access