Top 10 in a crosstab query

[Herman]

From a query I created a Crosstab query showing: "Titles
of ocupation", "Group Ocupation principal" and a total of
quantities.

Now I like to make a Top 10 or 15 List from the crosstab
query, How to do?

 

[Dejan]

I assume you have stored your cross tab under name
qryMyXtab.

Then something like

SELECT TOP 10 * FROM qryMyXtab

or

SELECT TOP 10 PERCENT * FROM qryMyXtab

should do the work

 

[herman]

Your option works fine in a select query but not in a
crosstab query.
This is the info from the SQL view of my crosstab-->

TRANSFORM Sum([hg-10 query].Quantity) AS SumOfQuantity
SELECT [hg-10 query].DESCRIP_TITULO_OCUPACIONAL, [hg-10
query].CLASE_OCUPACIONAL_NOMBRE, Sum([hg-10
query].Quantity) AS [Total Of Quantity]
FROM [hg-10 query]
GROUP BY [hg-10 query].DESCRIP_TITULO_OCUPACIONAL, [hg-10
query].CLASE_OCUPACIONAL_NOMBRE
PIVOT [hg-10 query].evento;