Sort Issue in Table

msmit8

Registered User.
Local time
Today, 11:58
Joined
Feb 17, 2012
Messages
13
I have a Microsoft Access database i'm working with and an issue with a table I can't solve. The table has one column. The column keeps defaulting to a sort of A to Z. I want the colunmn to NOT apply the sort A to Z. How do I solve this issue? Thanks!
 
Howzit

If the column is indexed then access will sort based on the index. Try taking out the index for this column if it has one.
 
Thanks for the reply. How can I tell if it's indexed or not?
 
Howzit

Go into the design view of the table and check there. Why do you want to remove this anyway. Indexing is a good way of improving performance when running queries and the like?
 
Last edited:
Also, what is the point about sort of a TABLE? You cannot ever ever ever rely on a TABLE being sorted in any particular way. Just because it displays as such is because there is an implicit query run when you open the table.
 
spike is correct. you shouldn't need to use a table directly. use a query based on the table, sorted as you require.
 

Users who are viewing this thread

Back
Top Bottom