>Do you want a clue or the answer? The clue is in rewording the problem:
>
>I want the first record that comes before the current audit record for the same ID.
>
>-Mike

Right, and I have been able to write a query to get the audit_id of the record that comes before a specific audit_id record, but I am not sure how to write it to return a rs that meets a certain date range. I'd hate to resort to a cursor.

So, I guess I want the answer.

BOb