How to avoid from overlapping between times per date

[Chipcom]

Hi

I need to know how to avoid from overlapping between times per date when the user is isernt a new data.


I thought to use dllookup function but it finds one result but if there is more than one result.

Date Ent Ext

1/1/2007 8:00 17:00
1/1/2007 9:00 16:00
1/1/2007 10:00 15:00

In this case there is overlapping and I need a code that avoiding this situation.

Thanks

 

[RuralGuy]

Maybe this link will help a bit.