UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Top 10 queries with categories    
 
   
marksmith
post Aug 5 2004, 10:26 AM
Post #1

New Member
Posts: 2
i have a table of invoices which are categorized by 'age' and by an 'owner'. i am trying to create a query which returns the top 10 invoices in both categories. i.e. top 10 invoices owned by 'mark' and 'less than 30 days' old. There are currently 20 'owners' and 8 invoice 'ages'.
Go to the top of the page
 
+
lotrtrotk
post Aug 5 2004, 10:42 AM
Post #2

New Member
Posts: 14
Select *whatever_fields* FROM *whatever_tables* WHERE *whatever_condition* ORDER BY *total_field* DESC LIMIT 10
Go to the top of the page
 
+
xteam
post Aug 5 2004, 10:44 AM
Post #3

UtterAccess VIP
Posts: 3,667
From: Toronto, ON
check THIS post

HTH
Go to the top of the page
 
+
marksmith
post Aug 5 2004, 11:52 AM
Post #4

New Member
Posts: 2
thank you vey much for your help, i checked the other post and have been able to solve my problem. Such a simple idea, but they are always the best ones.
Go to the top of the page
 
+
xteam
post Aug 5 2004, 12:26 PM
Post #5

UtterAccess VIP
Posts: 3,667
From: Toronto, ON
Welcome to UA !
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 04:50 AM