verify time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a web-based form where people enter times for employees that take
care of consumers. Most employees have more then one consumer so they have to
fill out more then one time sheet to be entered into the web-based form but
there are some employees that are putting a time say like 9 -10 on monday at
one consumers house and 945-11 on monday at another persons house. Would
there be a way I can set up a report or something that would verify that they
were not double charging the company??

Thanks
 
There are a number of possible approaches to this, depending on the
point in time at which you want the overlaps to be recognised. I think
that I would create a Query to sort the records in the relevant Table
by employee, date, and start time, and then step through a Recordset
based on that Query in VBA looking for overlaps between the start time
of each record and the latest end time of any previous record for the
same employee on the same day. I would set a flag in each record that
showed such an overlap and subsequently produce a simple report
showing the flagged records.


We have a web-based form where people enter times for employees that take
care of consumers. Most employees have more then one consumer so they have to
fill out more then one time sheet to be entered into the web-based form but
there are some employees that are putting a time say like 9 -10 on monday at
one consumers house and 945-11 on monday at another persons house. Would
there be a way I can set up a report or something that would verify that they
were not double charging the company??

Thanks
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top