Prev: Another Len function not working
Next: Hyperlink within Database 2007
From: Boon on 16 Feb 2010 13:18
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!


From: Jerry Whittle on 16 Feb 2010 14:06
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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Boon" wrote:

> 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!
>
>
> .
>
 | 
Pages: 1
Prev: Another Len function not working
Next: Hyperlink within Database 2007