Count Unique Records

[PonderingAccess]

Hello. I have a field named Product and need to count the number of unique Product records in a Query.

In other words, I want to know how many products a customer orders. The query currently finds the customer name. Now, I want count the number of products.

Thanks in advance.

[Grooz13]

well there is some tools in access you can work with when you do a query search for the GIANT greek E in the query ribbon

[PonderingAccess]

Thank you for your reply Grooz!

The problem using the big greek E is that I'm getting aggregate error messages.

It seems like this should be simple, like in Excel, telling Access to hide duplicates; but, I just can't figure it out.