Forced sort

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
 
M

Michel Walsh

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
 

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

Top