I am trying to create a macro to sort my values high to low.
The expression I have is: ="[TableA].[FieldtoSort] DESC"
SetValue: =[Forms]![TableA].[OrderByOn]
Expression = Yes
This appears to be working (i see the values are correctly sorted) but then the values do not look sorted anymore, then value re-starts sorting again.
In the database for example, I would see the below after applying the macro:
100
99
98
97
-1
60
59
58
41
40
Am I missing something in the expression?