Forum Discussion
Peter Mcdermott
Mar 20, 2017Iron Contributor
Creating a 'Unique record' count in Access Web App
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?
No RepliesBe the first to reply