Ascending e Descending Order of a Table.

[dfuas]

Happy new year everyone.

I have a table in which the data input comes from a dropdown list selected in a form combo box as:

contract signed
PIN issued
PDD issued
validation finished
Host country approval
EB approved
CER's issued.

I am designing a report in which I want to display the above list in Ascending or Descending order but as shown rather than alphabetically.
What I mean is no matter how the information is on the table the report showd display it in Ascending as contract signed, PIN issued, etc and in Descending as CER's issued, EB approved, Host country approval , etc.

Any ideas?

Thank you

dfuas

 

[pbaldy]

Have you looked at the "Sorting and Grouping" options?

 

[dfuas]

Yes but "Sorting and Grouping" is doing it in aphabetical order rather than the order I have got in there.

 

[pbaldy]

It should sort them in the order they appear in sorting and grouping, so if "contract signed" is the first field there, that should be the primary sort field. If that's not what's happening, perhaps you can post a sample db?

 

[dfuas]

I could post you a sample db, but the problem is that the order that I have in there is the order in the combo box. When I input the data in the table it goes depending on which option I choose from the above. So on the table the data could be in any order depending which selection I make. If it does not help then I will put in a sample db.

 

[neileg]

You need to add another field that you can use to sort on. So contract signed would be 1, PIN Issued 2, etc. Then you can sort the underlying data on that field.

 

[dfuas]

I see what you mean but I how would that work, I can't get around it. Please explain.