OrderBy Expression

  • Thread starter Thread starter DZ
  • Start date Start date
D

DZ

I want to set the orderby property on load of a form to sort field ascending
except I want a particular word that start with < (Example <NONE>) to be at
the end of the sort.

Me.OrderBy = "Category, ??? "

Example

Category
 
SELECT Fieldname
FROM Tablename
ORDER BY IIf(Fieldname = "<NONE>", 1, 0), Fieldname;
 
Back
Top