how to sort the order of values in a list box manually

[arixooo123]

hello dears,

I have a list box including the Shamsi Months ( Months in Persian), 

I tested all of the sort options (state,expressions,frequency...) but it does not get sorted as i wanted it to be.

I want to order them as it is in calender, apparently i have to sort them manually. but how?

thank you

[arixooo123]

I'm sorry but i don't get it, You see the month field has 12 possible values,the months in Persian, When i add the month list box, i want them to be ordered.

i did not get the load inline part, what is the amount field?  my original table has almost 20 column. not just 3.

[ashfaq_haseeb]

Hi,

As you could not give me sample file I have created a sample data that meet your requirement.

For month sorting did you follow my above post.

or you can use the below expression in sort tab.

=Match(Month,'اسفند','بهمن','دی','آذر','آبان','مهر','شهریور','مرداد','تیر','خرداد','اردیبهشت','فروردین')

Without seeing data I can't tell you how your data looks like.

No issue with the number of fields you have.

Hope it helped.

Regards

ASHFAQ

[aveeeeeee7en]

Hey Arman

I have seen your expression you have written in a wrong way. You have used Double Quotes ( '' ) for the Shamsi Months fields which is the wrong Format for writing the Expression.

Don't use double Quotes. Write the field names as it is.

Use this Expression:

Dual([Shamsi Month],Match([Shamsi Month],'فروردین','اردیبهشت','خرداد','تیر','مرداد','شهریور','مهر','آبان','آذر','دی','بهمن','اسفند'))

I am sure it will work for you.

[#5]

Thank you.  It worked for the problem I had with my project.