OrderBy Expression

[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

 

[Ken Snell \(MVP\)]

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