Querying distinct for multiple values

[Monty_99]

I suspect this is an easy question, but it has me stumped.



I use Access to track meetings with each customer. I have two tables:

tblContact (ID, Contact, Company)
tblMeetings (ID, ContactID, MtgDate)

I would like a query that says how many times I have met with people from each company, where multiple meetings on the same day with a company count as 1. So if I meet with three people from Company AAA on September 1, that only counts as one meeting. What am I doing wrong with my query?


SELECT DISTINCTROW tblContacts.Company, Count(*)
FROM tblMeetings INNER JOIN tblContacts ON tblMeetings.ContactID = tblContacts.ID
GROUP BY tblContacts.Company;


This is giving me multiples for each day. What am I doing wrong?

[xps35]

Try

SELECT Company, Count(MtgDate) AS Meetings 
FROM (SELECT DISTINCT Company, MtgDate FROM tblContacts INNER JOIN tblMeetings ON tblContacts.ID = tblMeetings.ContactID)
GROUP BY Company;

[cartwright]

Try

SELECT Company, Count(MtgDate) AS Meetings 
FROM (SELECT DISTINCT Company, MtgDate FROM tblContacts INNER JOIN tblMeetings ON tblContacts.ID = tblMeetings.ContactID)
GROUP BY Company;

Perfect. Thank you!