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);

 

[RiverGuy]

You should ask this in the Access forum, since crosstab queries are not standards across all RDBMS's

 

[Ielamrani]

I did thank you.
Ismail