Selecting First 10 Records

[ros794]

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]

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];

 

[ros794]

HI,

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

Cheers

Ros