Distinct Count (Date Specific)

I have a Member Form and a ServiceRecord Form.

Everytime a member comes in for a service it gets stored in the ServiceRecord form, as one visit, with the member name stored in for that visit and a specific service date.

With this information and using a query, I can run statistics on a report to show how many visits we had in a select time period. For example, if I want to know how many services we have rendered between Aug2023 and Sept2023, I have a calculated textbox set up on my report.

To simplify, lets pretend there was only 4 visits between this date range (between Aug 2023 and Sept 2023).

The Problem: If it was a new member each time that would be easy, just count the number of records you get the number of members that visited, however one member can visit more than once. Don't want to count this member twice.

In other words: if this month, we had rendered 4 services (=4 visits), but one member came in twice we basically only served 3 unique members during that month. I want to be able to see on my report's count field A >> ServicesRendered=4 and field B >> MembersServed=3 for this month.

Note:(Unique Values set to Yes in the query property sheet or Distinct in the query SQL statement does not work because the visit dates are different and required). I still want to be able to see how many unique members got served, but within a date range.

How would I go about setting this up?

Any help appreciated!