• I really didn't understand the requirement. Would be better if you could come up with a better example. Please have a look at the link in my signature to get to know how to get the best answers from forum posts.

    What does this statement mean??...."TypeID 11 occurs first and within 1 minute of TypeID 22"??

    Does this mean 11 occurs just 1 minute before 22??....

    This statement is a little better than the one mentioned above.

    "I need some assistance in finding records from a table where a certain ID exists within close proximity to another ID, but before the subsequent ID".

    It would be great if you could provide an example which contains the "certain ID", "another ID" and the "subsequent ID" mentioned in the above statement.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉