I am trying to set up a query that tells me how many people have been seen each month. I have a table with personal data and another with visits by these people. Some people can be seen more than once, either the same month or different months. What I am wanting is to see how many encounters there are for each month. The current data is just dummy data. So I want to see it say 2 encounters for April etc. I have tried using count under "group by" but it doesn't work. I have attached the query design and the result when I run the query. Some help would be appreciated