Order sorting

Title

Order sorting

Post

Hi Can you help me please.

I have created a New layout report and want to view and print in a particular order, I have created field for this purpose one representing the month, one the day of the month and another that I place a number in representing the order that I want them viewed and printed in for each day. I selected these fields when setting up the new layout in ascending order month then day and then the number field but but it will not sort in order can you tell me what i'm doing wrong thank you.

You are on the layout (view as list), the fields are on the layout (visible or not), you choose Sort from the top menu,put the Month | Day | Order fields in the sort dialog box (all ascending order) and what is the result?

TextAlphabetically. Numbers sort by character position. (Example of an ascending sort: 1, 11, 2.) Numbers sort before letters. Non-alphanumeric values before the first word are ignored (unless you change the sort language to Unicode).