Change month order in prompt value display

[DvlprDc]

Hi there -

I tried to find info on this in the forum, but had no luck. I'm hoping someone can please tell me how, with a value prompt (listing months January - December), one can change the listing of values to not be alphabetical.Ã,  Right now April is my first month listing & September my last.Ã,  I want it to start with January and end with December. I looked in the properties of the value prompt but didn't see anything there that could help me. Any ideas ?


Much thanks -

[bdybldr]

What data are you using to populate the value prompt?  Static choice or database table?

[DvlprDc]

I am using the database table.

[Draoued]

I suppose you have a dedicated query to populate the Prompt .

This query is most probably containing only 1 field , like Month_Name ( Jan -> Dec )
Then of course this is sorted in Alpha order.

What you can do it s adding a Month Number field ( 1 -> 12 ) and do the sort on this field.
Mark the Month_Name as no Sort

Then this field is not used in the prompt , nor visible to end-user.

[Boris-A]

Adding to what was suggested by Draoued, you can even use this "sort Key" to be used in your prompt, but display the month names.

[DvlprDc]

That worked Draoued.

THANKS !!

[bdybldr]

DvlprDc,
Please close this thread according to the board rules.Ã,  Thanks.