Right now on one of my forms I am doing the standard Sort alphabetically. Is there a way I can do a conditional sorting? Like if [ColumnA]=1 put that first, if [ColumnC]=4 put that 2nd if [ColumnJ]=2 put that 3rd. So they are not in order or alphabetically but I will have simple set values just want to put them up top versus alphabetically. Ideas?
