Sort Issue in Table

[msmit8]

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!

 

[Kiwiman]

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.

 

[msmit8]

Thanks for the reply. How can I tell if it's indexed or not?

 

[Kiwiman]

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?

 

[spikepl]

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.

 

[gemma-the-husky]

spike is correct. you shouldn't need to use a table directly. use a query based on the table, sorted as you require.