You can group by client and add another field from your table and count it.
If you have in the table the Client and the OrderNum you can use the
following SQL or something similar
SELECT Orders.Client, Count(Orders.OrderNum) AS NumberOfOrders
FROM Orders
GROUP BY Orders.Client
ORDER BY Count(Orders.OrderNum) DESC;
Regards,
Manuel
-----Messaggio originale-----
Da: AccessDevelopers@yahoogroups.com
[mailto:[EMAIL PROTECTED] Per conto di drhovasse
Inviato: giovedì 19 gennaio 2006 17.27
A: AccessDevelopers@yahoogroups.com
Oggetto: [AccessDevelopers] Query database
I have a database that has all orders placed for the fiscal year. I
am trying to run a query that will give me the customers that have
placed the most orders for the year back. Is there away to do that
without knowing the customer name?
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
<<attachment: winmail.dat>>
