So I'm an Access beginner, and I'm taking a college class in Database Management. I've completed my assignment however I wanted to explore and take it a bit further.
I have a basic query that returns results for patients in a certain city. However because I want to include doctor information in the query as well, duplicate records are showing up because patients can have more than one visit.
In my query I just want to eliminate the duplicate visit records and show the most recent visit only. So for example I found this question posted on another forum at stackoverflow, however the answers were all using SQL code and I haven't been introduced to it yet so I was confused. I was wondering if there was a way to do this without using SQL code, if not can someone explain what the code would do?
Sorry it's a bit out of alignment ...
|--ID--|-Type-|-Code-|--Date--|
| 1 | A | 11 |11/07/13|
| 2 | A | 11 |11/07/13|
| 2 | B | 12 |10/07/13| <-- don't want this record from ID=2 as
| 3 | A | 11 |11/07/13| there is a more recent date for it
| 4 | A | 10 |11/07/13| than 10/07/2013
| 5 | A | 11 |11/07/13|