Top Values Property For Access Query

[BOBAIAM]

I have an Access 2000 query which I only want to show the 10 ten values for entries within a subgroup (not the entire report) Does anyone know how to show these top values? I have set the top values property on the query sheet, but the results of the query are the top ten results for all records.

Thanks,
Bob

 

[WayneRyan]

Bob:

From Access Help

Dim strGetSQL As String
strGetSQL = "SELECT TOP 10 Products.[ProductName] " _
& "AS TenMostExpensiveProducts, Products.UnitPrice FROM Products " _
& "ORDER BY Products.[UnitPrice] DESC;"
Me.RecordSource = strGetSQL