I have two tables, related by Member ID. One contains Member ID, people's names, addresses etc. The other contains Member ID and a Meeting ID going back over many years. In recent times, some members attended the 2001 meeting only. Some attended the 2002 meeting only. Some attended both. I have 2 problems.
When I run a query to find "2001 or 2002" attendees, some people's names appear twice in the list, once beside 2001 then again beside 2002. How do I remove these duplications of names and addresses in my list of who went to both?
How do I set up a query to list just those who went to the 2001 meeting, not both?