I have a table Category with P.K categories.
One of the categories is "Discount", I want a query that displays it at the end of the list.
I run the following query, and it works perfectly: SELECT categories FROM Category ORDER BY IIf(categories<>'Discount',1,2), categories
The problem is when I generate a report that is grouped on categories, I only have 2 choices: with A on top and with Z on top, and there is no place to put a custom sort.
I tried to sort the report query but didn't work.
I also changed the order by property of the report and still didn't work.
I think the sorting that is applied to the group (with A on top) is overriding all my sorts attempts
Any idea on how to apply a custom sort on a report?