Sort Order Again

[Stephen Hartman]

Within a report I know I can use the sorting and grouping properties to sort
ascending or descending by a specific field, however, I want to sort by a
specific field that is sorted by a numeric value generated within a table.
Is this possible via code or another option, or am I stuck with
ascending/descending?

TIA

 

[Dirk Goldgar]

Within a report I know I can use the sorting and grouping properties
to sort ascending or descending by a specific field, however, I want
to sort by a specific field that is sorted by a numeric value
generated within a table. Is this possible via code or another
option, or am I stuck with ascending/descending?

I'm not sure what you mean. Do you mean there's a lookup table that
assigns a numeric value to each of the values in this particular field,
and you want to sort based on the looked-up value? If so, add the
lookup table to the report's recordsource, include the numeric field in
the fields selected by the recordsource query, and then use
sorting/grouping to sort by that field.