Forced sort

  • Thread starter Thread starter Martin Walke
  • Start date Start date
M

Martin Walke

Hi,

I wonder if anyone can help me. I have an access table with a field that I
want to sort in a particular order - not just alphabetically. In my case,
the field contains values such as 'Filled List', Field', 'Check box', 'List'
and I want to view the table with the 'Filled' value first and then all the
others. Is there a way to do this?

TIA
Martin Walke
 
Hi,


.... ORDER BY FieldName Like "Filled*", FiedName


would first order accordingly to the Boolean value (True = -1, False=0)
resulting from the comparison, then, to break equality, accordingly to the
fieldName value itself.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top