I have a query that includes the following:
The query displays perfectly sorted, according to the value returned with "SortFld", when opened in design view, ("!"), but not when the query is used as the RecordSource of my report. Along with the others, there is a text box in the detail section bound to "SortFld" and it displays as one would expect. But again, the sort order of the report does not correspond to the "SortFld" expression in the query.
Is there something inherently wrong with the use of such an expression as I'm using it?
(snip sample of open query)