Access 2002
I have a simple question to solve, I have a list of consultations in a table I would like to select the second last consultation for each person. IS there anyway to do this using the Max function, minus the highest date or another way?
the table is like this
PersonID ConsultationDate
1 10/11/2000
1 13/11/2000
1 01/12/2000
2 28/10/2000
3 14/10/2000
3 01/11/2000
3 21/12/2000
I have a simple question to solve, I have a list of consultations in a table I would like to select the second last consultation for each person. IS there anyway to do this using the Max function, minus the highest date or another way?
the table is like this
PersonID ConsultationDate
1 10/11/2000
1 13/11/2000
1 01/12/2000
2 28/10/2000
3 14/10/2000
3 01/11/2000
3 21/12/2000
