ORDERBY Property

[kooley]

I have a report that groups on a status field that is a combo box. I need to specify the order that the statuses should appear on the report (other than ascending or descending). Can the ORDERBY property be used for this & if so, I am unsure as to the proper syntax to use. Thank you for any help.

 

[dhookom]

The Order By property is generally useless especially if you have Sorting and Grouping set. Allen Browne has code to set sorting and grouping at runtime at

http://www.allenbrowne.com/ser-33.html.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[kooley]

That is the conclusion I was coming to. Oh well! Thank you for your help. I am thinking of numbering the statuses in the order they need to appear in the report & then the sort of ascending or descending would work. Have a wonderful day!