Hi
I have just joined the forum.

We have over 200 persons working freelance on assignments in the field. They submit data on completing their daily assignments. The Access Database has a CompletionTable with JobNumber as primary key, EmployeeName for the freelance worker, AssignmentDate as date for the actual assignment being carried out, AssignmentTime as the beginning time for assignment and CompletionTime for the time assignment completed.

Is their any way to check for logical errors to find if on a given AssignmentDate there is an AssignmentTime that overlaps another assignment by the same person.

An employee may have number of assignments on a particular day from null to upto five.

I have a column 'DataAlert' to have some value to identify in case of an error so that wrong data could be edited.

Serj

for each employee/Date

read in each row and store the start time and end time in arrays so you end up with

StartTime(0) = 10:30 : EndTime(0) = 11:30
StartTime(1) = 12:30 : EndTime(2) = 13:30 etc
then its just a matter of comparing any time to each start/end time in each element of the array.
I use this technique to validate room bookings.