Sorting in select query. manually

  • Thread starter Thread starter Boon
  • Start date Start date
B

Boon

Hello,

I have a select query and I would like to sort on the field month. but I
want to be able to specify the order myself (not descending nor ascending).
how can I do this?

thank you!
 
You create a table with the data you which you would see in the Month field
and the sort order that you want. You then join these two tables in the query
and sort on it.

Something like this:

Month MonthSort
Jan 12
Feb 11
Mar 3

and so on.
 
Back
Top