Sorting in list view

Sorting in list view

I imported a data file to create my Creator table.

1st problem is the records are now in reverse order

2nd, weirder, problem is that when I sort by Last name column, it seems to sort only within whatever the current number or records per page is. So, it will sort only the first 30 records out of 275. As if it first breaks the 275 records up into chunks of 30 and then sorts each chunk. But I expect it to sort all 275 then break that into chunks of 30 per page.
rdtietjen