Unanswered: Urgent! How to sort report category by my own rules, not alphabetical?
I have a report, run from a query, which lists all the current menu items and displays this in a menu-style format. However my problem is this. I have the label 'Category' as a separate, bold entity, and it currently lists the categories, with the appropriate menu items underneath, in alphabetical order:
However I need to somehow change it so that instead of this, it is in the order that the categories are displayed in their combo boxes on forms; or to actually set it in the report (if possible) to list in this order:
as any standard restaurant menu would be displayed.