Top 5 Speed Figures Per Entrant

[FREDDY67]

I have a query which returns each entrant with the speed figures in a descending order for previous races, I wish my query to return the top 5 speed figures per entrant or if the entrant has less than 5 previous runs it needs to return all available data.

I am not VBA literate, so as simple as possible please, thanks.

Freddy67

 

[Alc]

Have a read around the 'SELECT TOP' function. Sounds like what you need.

 

[FREDDY67]

Cheers.

I have had a look through the select top function but as far as I can tell if I ask it to return the top 50 results it will, but if one entrant has 10 speed figures better than another entrant the it will return the 10 better speed figures of that entrant and none from the other entrant. What I require is the best 5 speed figures for each entrant.

Thanks.

Freddy67

 

[Alc]

Looks like this post
may be along the same lines.

http://www.access-programmers.co.uk/forums/showthread.php?t=126750

 

[pbaldy]

Another solution:

http://support.microsoft.com/kb/210039/en-us

 

[FREDDY67]

thanks for the links, I'll have a read & experiment.

Cheers.