Need your help on this problem.
Let say table name call tbl_range and 2 field call No1 and No2
I have this set of record :- No1No2
My problem, i want to check if user insert another set no No1 : 1500 No2 : 2500. So, this means that range already clash with another range. If this happened it will return 2 record (1000 - 2000) and (2001 - 3000). Can it be done and how?