Sorting

[Ielamrani]

Hi,
I am trying to sort this Crosstab query by Total Of Authorization Number. Is it possible? I include the SQL.Thanks in advance.
Ismail

TRANSFORM Count([qry -History Log Count].[Authorization Number]) AS [CountOfAuthorization Number]
SELECT [qry -History Log Count].AUTHPCP, [qry -History Log Count].[AUTH PCP NAME], Count([qry -History Log Count].[Authorization Number]) AS [Total Of Authorization Number]
FROM [qry -History Log Count]
GROUP BY [qry -History Log Count].AUTHPCP, [qry -History Log Count].[AUTH PCP NAME]
ORDER BY Right([Date],4) & "/" & Left([Date],2)
PIVOT Right([Date],4) & "/" & Left([Date],2);

 

[PHV]

Have you tried this clause ?
ORDER BY 3

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ielamrani]

I tried it but it's still not working.
The last 2 line look like this:

ORDER BY 3
PIVOT Right([Date],4) & "/" & Left([Date],2);

thanks

 

[Ielamrani]

I could not do it from the same query, so I created a new quer with the clause you sent me and it worked.
thanks for you help
Ismail