not getting month field in correct order.

[Kohli]

In my table i have fields like

Year, Month

2010 ,Feb

2010, Aug

2010, July

2010, Sep

2010, Oct

2010, Jan,

2010, Apr

2010, Mar

2010, May

2010, Jun

2010, Nov

2010, Dec

I want put month in a correct order. What i have to do ?

[rubenmarin]

Hi, you can create a number field and use this field to sort values:

Num(Date#(Year&Month, 'YYYYMMM')) as numDate