Challenging Distinct Record Count in an Access Report (1 Viewer)

Hello,

:banghead: I have created a report in Access that has the following structure: Please see attached sample report image.

While I can create a simple record count of the Application ID and place it in the Region section, I am struggling to create one the would give me a distinct or unique count of applications within the Region. In the above example of a total of 3 applications since Canada and Mexico use the same type of application, in this case, MS Word.

It has been suggested that I create a query. If so, how is that done? Do I create an unbound field in the Region Heading of the report and paste the SQL statement inside? Please provide a bit more detail and a sample query syntax if possible.

Thank you!

Query1 would be
Select Distinct Region, ApplicationID
From YourTable

Then the Control source for the count field would be

= DCount("*", "Query1", "Region = '" & [Region] "'")

Cross posted at https://social.msdn.microsoft.com/Forums/office/en-US/5942415e-44c9-4569-8688-02228f8fcbda/challenging-distinct-record-count-in-group-heading-access-report?forum=accessdev

Please follow standard forum etiquette if you cross post.
Say you have done so and provide a link so people don't waste their time