Report grouping (1 Viewer)

[iain1978]

Hopefully an easy one for someone.

I have a report that is grouped by a column called RAG status (Red, Amber, Green) to reflect the status of the respective issue.

I now have a status report that I run and wish to order the report so Red issues are at the top followed by Amber and finally Green issues.

Can anyone advise me how I tell my report to order the records in this way and not alphabetically.

 

[Rich]

Either use the Switch function or a Select case purpose built function to add the numeric value 1;2 or 3 to your query, you can then group and sort on that value