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?

[Jeremy_Oglesby]

What type of field is the one you are trying to sort by? What kind of value does it hold?

[Karl_Greenberg]

thanks for fast response! The field is text - various publications, like NY Times, etc. I have reporters from different pubs, and the list is alphabetical by pubs.

[Karl_Greenberg]

Strangely, when I attempt to integrated those records into the alphabetical-by-publication list, it won’t happen

[Jeremy_Oglesby]

So the field contains text, but what TYPE of field is it? Is it a linked record field? Is it a Formula field? Is it just a Single-Line Text Field?

[Karl_Greenberg]

Oh! I … don’t know. to the left of the field name is an icon representing a bulleted list, but I don’t know what kind of field it is.

[Jeremy_Oglesby]

Like this?

[Karl_Greenberg]

yes. that’s right, it looks like that

[Karl_Greenberg]

when I type in the name of a publication it automatically creates a colored button as field entry

[Jeremy_Oglesby]

So then your sort menu says “First-Last”, not “A-Z” right?