You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
rhb
@Chalfie
Right. I'm trying to find duplicates in my access database.
People can be in this db multiple times, because they could have different infections at different times.
i.e
joe smith, has cyrpto in 2014, measles in 2015, and scarlet fever in 2016.
Sometimes, people make mistakes and enter data incorrectly so that
Jane Brown has crypto in 2014 and crypto in 2014.
How can I build a query to say:
show me all the people in the database with the same name, tell me how many times they feature in the database, and give me all the diagnoses they have?
Currently my query says
show me name, dob, first diagn, last diagn
group by name dob
having name >1
how do i get the second and third diagn?