Selecting First 10 Records

ros794

New member
Local time
Today, 20:51
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
 
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.
 
SELECT TOP 10 [YourTable].*
FROM [YourTable];
 
HI,

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

Cheers

Ros
 

Users who are viewing this thread

Back
Top Bottom