Count unique field values within query
Posted on 2010-08-20
I am hoping to be able to eliminate additional queries that are used simply to count unique values in a query.
Here's a sample of fields in my base query:
I have a summary query that returns:
Averages for CheckPrice and OtherPrice
Count of unique values in ExpNo (2 queries-One to group ExpNo and then one to count those records)
Count of unique values in CheckProduct (2 queries-One to group CheckProduct and then one to count those records)
Count of unique values in OtherProduct (2 queries-One to group OtherProduct and then one to count those records)
I am repeating this process for 4 different sets of records. Surely, there's a better way. Any suggestions would be greatly appreciated.