RE: [AccessDevelopers] Query database

[Lava Boggavarapu]

Try (something like the below sql)   SELECT Customer, Count(0) FROM table1 GROUP BY Customer ORDER BY Count(0) DESC   -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of drhovasse Sent: Thursday, January 19, 2006 11:27 AM To: AccessDevelopers@yahoogroups.com Subject: [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? The information contained in this message and any attachments (the "Message") is intended for specific individual(s), and may be confidential or proprietary. If you are not the intended recipient, please notify the sender immediately, delete this Message and do not disclose. Messages are not secure or error free and can contain viruses and the sender is not liable for any of these occurrences. The sender reserves the right to monitor, record and retain Messages. Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.   To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.