cust with multiple orders that differ

[slimjen]

All, using Access 2016. Having a senior moment. I have a cust table with order numbers. I want to query only those customers with multiple order numbers but the order numbers are different. So if a customer have 3 different order numbers but 2 are the same order number; I just want it to list the 2 different ones. I have the following:

select  customerid,       count(*)as order_count
from    orders
groupby
        customerid having  count(*)>1

This give me all the customers and the count of orders. I need to exclude if they don't have multiple different orders.

[rpeare]

SELECT CustomerID, OrderNumber FROM Orders GROUP by CustomerID, OrderNumber

you can throw in a count if you want to, but it's not really necessary if you're just after a list of unique customers/orders numbers

[slimjen]

Got!...Thanks so much! like I said; I was having a moment.