Sorting on a Report

[Flyboy65]

I am trying to replicate a Profit/Loss report. I have Revenue, Expense, and COGs under my types header. The only option for the sort order is either ascending and descending. I'm wondering if there is another way to sort so I can show Revenue, COGs, then Expense.

[June7]

Calculate a numeric or letter value for each category and sort on that. Calculate in query or in report design.

Switch(fieldname = "Revenue",1, fieldname="COGs",2, fieldname="Expense",3, True,4)

Or have a Types table where this value is a field and include that table in report RecordSource.

ID	Cat
1	Revenue
2	COGs
3	Expense

[Flyboy65]

June7, Thanks very much for your help....works perfectly now.