I'm using MS Access 2003 and I have two tables, tablePatients and tableTreatments where tablePatients contains a specific patient and any of these patients may have one or more treatments which is linked to tableTreatments.
So far I've used this question to retrieve all patients and their treatment:
But now I would like to retrieve only the second (or third, or fourth or X..) treatment for all the patients based on the treatment date, so using the example above the data I would like to retrieve is:
Is there anyone having an idea?
You may use the below query.
hope this would help