[SOLVED] Custom Row Heading Sorting in Crosstab Query!
Hi,
Been searching this and tried everything I know with no luck
I have a table name tblOrder with field OrderID , OrderType and OrderStatus
I created a crosstab query to group by OrderType and count the total of orders, opened orders and closed orders
As you can see, the row heading is sorting ascending by OrderType (Parts, Services, Shipment)
How can I custom sort the row heading to show service in top, parts in middle and shipment at bottom
database is attached.
Hi,
Been searching this and tried everything I know with no luck
I have a table name tblOrder with field OrderID , OrderType and OrderStatus
I created a crosstab query to group by OrderType and count the total of orders, opened orders and closed orders
As you can see, the row heading is sorting ascending by OrderType (Parts, Services, Shipment)
How can I custom sort the row heading to show service in top, parts in middle and shipment at bottom
database is attached.
Attachments
Last edited: