Need help with eliminating duplicate entries in a query.

[LH731]

I am pretty new at Access, but below is the code for my query. I am trying to obtain the most current meeting/contact date and its details for each meeting/contact. A few of the companies show up several times on the query even though I have chosen to "group by" company name. It works correctly on some but not others.

SELECT Max([Meetings/Contacts].[Meeting Date]) 
AS [MaxOfMeeting Date], [Meetings/Contacts].[Company Name], [Meetings/Contacts].[Meeting  Time], [Meetings/Contacts].[Meeting Location], [Meetings/Contacts].[Our Contact], [Meetings/Contacts].[Met/Conversation With], [Meetings/Contacts].[Meeting Summary]
FROM [Meetings/Contacts]
GROUP BY [Meetings/Contacts].[Company Name], [Meetings/Contacts].[Meeting  Time], [Meetings/Contacts].[Meeting Location], [Meetings/Contacts].[Our Contact], [Meetings/Contacts].[Met/Conversation With], [Meetings/Contacts].[Meeting Summary]
ORDER BY [Meetings/Contacts].[Company Name];

[Rabbit]

That's because you're also grouping by [Meetings/Contacts].[Meeting Time], [Meetings/Contacts].[Meeting Location], [Meetings/Contacts].[Our Contact], [Meetings/Contacts].[Met/Conversation With], [Meetings/Contacts].[Meeting Summary]. Grouping means that it's going to summarize on each distinct value combination of the group by fields.

What you need to do is drop all those other group by fields and get just the max date for each company. You then join that back to the table on the company and date to get the details of just those meetings.

[LH731]

That worked, but now I'm in design view of the query and have added the meetings/contacts table. How do I join a query to a table?

[Rabbit]

The same way you join a table to a table.

[LH731]

Think I've got it now. Thanks sooo much for your help!!

[Rabbit]

Not a problem, good luck with the reset of your project!