List of customers with more than one order

[duran007]

How do I show clients that have more than 6 orders? I have a table filled with orders but only want to have a list clients that had 6 or more orders? i have a customer number for each client. For example:

Customer# | Product | Dollar Amount | Date of order



thanks

 

[alansidman]

Try this:

SELECT Table1.CustNr, Count(Table1.DateofOrder) AS CountOfDateofOrder
FROM Table1
GROUP BY Table1.CustNr
HAVING (((Count(Table1.DateofOrder))>6));

Alan