force order of query results

[gutmj]

Hi All

I would like to force order of query results so I could use the output directly in Excel as chart data.

The query returns cost categories with total cost per category:

distribution 50
duties 20
manufacturing 60
warehousing 40

is there a way to force certain order for cost categories in the query output?, to be shown as:

distribution 50
warehousing 40
manufacturing 60
duties 20

I don't think there is but perhaps someone will come up with something clever.

Thanks in advance

 

[VilaRestal]

you could add a numeric field to the categories lookup table that would represent the order you wanted to appear in... then order by that field in the query.