Sort Order

  • Thread starter Thread starter Stephen Hartman
  • Start date Start date
S

Stephen Hartman

Can a field be forced to sort a specific way and not just ascending or
descending?

TIA
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort Order Again 1
sorting tables 5
Record Source Order! 2
Indexes and sort order 1
Combo Box - Specifying Sort Order 1
Sort order in report 2
How to add a sort expression in criteria 1
Question cc Sorting reports into a specific order 1

Back
Top