Get second MIN record
Posted on 1998-07-23
I'm using Access 97. I have a database of requests for materials. Each person has an ID number. When a request is made, a record gets put into a request table. The record contains the date of the request. For one report, I need to get the first request for each person. This is easy, I group on the ID number and take the MIN of the date field.
Now I need to determine the second request for each of the people who have requested more than once. They may have requested up to 10 times, so I can't just use the MAX of the date. Also, my report needs to show the number of people who submitted a second request listed by date.
I have over 50,000 requests from about 35,000 separate IDs.
How can I do this?