Can a field be forced to sort a specific way and not just ascending or descending? TIA
S Stephen Hartman Sep 22, 2004 #1 Can a field be forced to sort a specific way and not just ascending or descending? TIA
A Allen Browne Sep 22, 2004 #2 To specify a different sort order, create a lookup table with a record for each possible value, and a number field for the sort order you want. You can then include the lookup table in your query, and sort by the number field.
To specify a different sort order, create a lookup table with a record for each possible value, and a number field for the sort order you want. You can then include the lookup table in your query, and sort by the number field.