Selecting First 10 Records (1 Viewer)

ros794

New member
Local time
Today, 09:05
Joined
Oct 13, 2005
Messages
9
Hi,

I have a query that gives an out put of 'worst offenders'. these offenders are in order of on field ascending (number of entries made per week) and another field descending (total sales).
It is by the combination of the sorting of these fields that we have an ordered list of offenders.

For my report i want to only see the top 10 records of this sorted list.

so for this selection i simply want to select the first 10 records of the ordered list. I cant make a selection by any one particular field(as explained above)

i have looked into the 'select top' functions and 'dfirst', but I dont think they'll work for me.

Any ideas?
Slighlty confused,
Rosxx
 

statsman

Active member
Local time
Today, 05:05
Joined
Aug 22, 2004
Messages
2,088
On the next to top line in your query design view there is a white box. It is set to "All" as a default. Reset it to 10.
 

___

¯¯¯¯¯
Local time
Today, 09:05
Joined
Nov 27, 2003
Messages
595
SELECT TOP 10 [YourTable].*
FROM [YourTable];
 

ros794

New member
Local time
Today, 09:05
Joined
Oct 13, 2005
Messages
9
HI,

Thanks so much for that! I didn't relaise it was so easy!

Cheers

Ros
 

Users who are viewing this thread

Top Bottom