I have a database but for some reason I cannot use the "sort" option on a specific column in a table. I cannot work out why...
On one column (FirstName) in the table, i can sort on its contents by clicking the down arrow in the column heading and selecting (Select All), (Blanks), and then all the column entries. See first image attached.
On the column Surname (which seems to be identical in terms of properties), the contents of the column are not displayed when I click the down arrow in the column heading. See second image attached.
Any ideas why? Many thanks.