Creating a 'Unique record' count in Access Web App

Iron Contributor

There is a situation where I am trying to find a count of how many unique values are associated with an item on a related table. How can I find this?


Here's the scenario


Business Opportunities

1 ACME Widgets


Quotes Generated

1 Quote 1 for ACME Widgets by Paul

2 Quote 2 for ACME Widgets by Paul


The desired output for Paul is

Business Opportunities: 1

Quotes Generated: 2


However, when I run COUNT for opportunties, it shows 2, because two quotes are tied to the opportunity--disregarding that there is only 1 unique business opporutnity.


How can I overcome this obstable and achieve the desired output in bold?

0 Replies