Search results

I am new to Access and this forum. I apologize. I will post a new thread next time. I appreciate your response. My data is filtered and sorted in my query to provide a historical perspective for the user to view previous events and changes. I think I understand what you are trying to say...

The solution to reference previous record in a query when the ID's are not sequential is found on a Microsoft web site with the code PrevRecVal function. It worked exactly as desired! Search for PrevRecVal on Google or put this in an open web browser to jump right to it...

Hey shravshetty , I have a similar problem. My query is displaying the records based on my own criteria and sorted correctly. I cannot use ID when referring to previous or next records because they are not in sequencial order. I have been trying to determine how to add an autonumber or counter...