Forum Discussion

Peter Mcdermott's avatar
Peter Mcdermott
Iron Contributor
Mar 20, 2017

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

Share

Resources