Top 10 in a crosstab query

  • Thread starter Thread starter Herman
  • Start date Start date
H

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?
 
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
:-)
 
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;
 
Back
Top