Hello,
I have created a report in Access that has the following structure:
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!