Customize Sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Is there a way that you can customize the sorting? For example: I have
this field A value (Market, Preschool, Solitaire, Synopsis) right now, it is
sort in ascending order but customer wants (Market, Preschool, Synopsis,
Solitaire). Leave first 2 value but put "Synopsis" before "Solitaire. Is
there a way?

Thank you as always.
 
Yep. Add a number field in the table and put the number 1 for the first in
the sort, 2 for the second, ect. Sort on this new field.

Now if you have multiple Markets for example, you might need another table
with two fields: one for the value and another for the sort order. Then you
need to add this new table to queries and sort by it.
 
Back
Top