Creating a 'Unique record' count in Access Web App

%3CLINGO-SUB%20id%3D%22lingo-sub-54647%22%20slang%3D%22en-US%22%3ECreating%20a%20'Unique%20record'%20count%20in%20Access%20Web%20App%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-54647%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20is%20a%20situation%20where%20I%20am%20trying%20to%20find%20a%20count%20of%20how%20many%20unique%20values%20are%20associated%20with%20an%20item%20on%20a%20related%20table.%20How%20can%20I%20find%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20scenario%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBusiness%20Opportunities%3C%2FP%3E%3CP%3E1%20ACME%20Widgets%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuotes%20Generated%3C%2FP%3E%3CP%3E1%20Quote%201%20for%20ACME%20Widgets%20by%20Paul%3C%2FP%3E%3CP%3E2%20Quote%202%20for%20ACME%20Widgets%20by%20Paul%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20desired%20output%20for%20Paul%20is%3C%2FP%3E%3CP%3E%3CSTRONG%3EBusiness%20Opportunities%3A%201%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EQuotes%20Generated%3A%202%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20when%20I%20run%20COUNT%20for%20opportunties%2C%20it%20shows%202%2C%20because%20two%20quotes%20are%20tied%20to%20the%20opportunity--disregarding%20that%20there%20is%20only%201%20unique%20business%20opporutnity.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20overcome%20this%20obstable%20and%20achieve%20the%20desired%20output%20in%20bold%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-54647%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%20Web%20App%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent 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