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 -
What data are you using to populate the value prompt? Static choice or database table?
I am using the database table.
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.
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.
That worked Draoued.
THANKS !!
DvlprDc,
Please close this thread according to the board rules.Ã, Thanks.