Problem with sorting records alphabetically

[Karl_Greenberg]

Many of my records are trapped at the bottom of my base! Attempting to sort alphabetically by one of the key fields isn’t working! Why?

[Karl_Greenberg]

Yes, it says first to last, not a-z

[Jeremy_Oglesby]

Those are sorted by the order of the options in the Field menu:

You can alphabetize them by hitting that “Alphabetize” button in the Field menu options.

EDIT – It’s important to note that if you add a new Publication to that list, it will automatically go to the bottom of the list, regardless of its proper alphabetical position in the list; to have newly added options properly sorted, you need to repeat this process of hitting the “Alphabetize” button in the Field Menu options.

[Karl_Greenberg]

Ah!!! Okay, I’ll try…

[Karl_Greenberg]

Well, strangely it didn’t work. they’re still down there. I wonder if they are somehow accidentally entered in some protected format, or were sorted as a group by some other field

[Jeremy_Oglesby]

Re-apply the sort by clicking “Apply” in the Sort Menu:

EDIT – this can be done quickly in the future by hitting ⌘/ctrl+Shift+S (to open the sort menu) and then hitting enter (to reapply the sort).

[Karl_Greenberg]

Got it. okay will do

[Karl_Greenberg]

YES!! Success! it worked.