See that is where the difficulty lies. For every line item that is ordered on the same order the customer name, customer number, sales order number and purchase order are repeated. Some orders have a 100 or more line items on it.
Thank you for your help --- In AccessDevelopers@yahoogroups.com, "Lava Boggavarapu" <[EMAIL PROTECTED]> wrote: > > 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? > > > > > > > Please zip all files prior to uploading to Files section. > > > > > ________________________________ > > YAHOO! GROUPS LINKS > > > > * Visit your group "AccessDevelopers > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Unsubscribe > > > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/> . > > > > ________________________________ > > > > 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 <*> 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/
