I'm trying to sort the records in this database using the two left-most fields (apart from the extreme left,the first field, which is just an ID number to show the order in which the records were entered.) Even though the sort cell of this ID field in design view isn't selected, Access persists in sorting on this field first. Even hiding it makes no difference. What am I doing wrong? Many thanks.
It's in the query design view where the sort fields are selected. Say I have three fields, A,B and C, from left to right. In the design grid, Select sort on field B, then sort on field C. Field A is marked as Not Sorted, but it is still sorted first. That's the problem. Thanks for your response.
Many thanks. I should have mentioned that it's in the Table view I'm having the problem. Even if I shift that field to the right-most position, that's the one that's sorted first in the Table view even though it's marked as not sorted. It's really no great hassle I suppose, just puzzling. The query view is OK.
This thread is now locked and can not be replied to.