In the query given below which is done in Access
SELECT [Q Test].[Lead Business], [Q Test].Region, Avg([Q Test].[Cycle time days]) AS [AvgOfCycle time days], Count([Q Test].[Contract ID]) AS [CountOfContract ID]
FROM [Q Test]
GROUP BY [Q Test].[Lead Business], [Q Test].Region;
The field Count([Q Test].[Contract ID]) lists the count of contract ids including duplicates.
What should I do to let Access Return only count of unique values. For example, there are 100 records having contract id out of which only 10 are unique, balance 90 are repetitions.
While currently access returns 100 for the field, I want access to return 10 which is unique values for the field.
Any help would be much appreciated.