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?