Sorting a table....

[egg]

Hi The beginner here again.....

How do I set a table to sort by specific fields???

ie i have an ID field which is an autonumber, then 6 fields

I want the table to autosort first by a field called [rank], and then by a field called [name]

Thanks in advance

Egg

 

[Michael J Ross]

Hi,

Open your table in design view and click on Properties, In Order By enter [rank];[name]

Sorry scratch that doesn't seem to work.

 

[RuralGuy]

Tables do not sort. Create a query of the table to sort it.

 

[Michael J Ross]

You can use indexes to sort the table, again in the design view of the table.

 

[egg]

Ah right Ill look at the indexes then....

Looking the table its already sorting by name, I just need it to sort by rank first.

Thanks

 

[egg]

The indexing allow seems to sort by one field...

 

[RuralGuy]

Is there some reason you choose not to use a query to sort the table?

 

[egg]

I had set a button to output the table to an xls file.... After what you have said you have sorted it for me. I can set up a query and then output the query to the xls file...

Sorry for overlooking it......

 

[The_Doc_Man]

In theory, tables are NEVER sorted except by accident of recent events. Instead, Access tracks the records via a complex pointer system.

If the table has a prime key, a Compress sorts the order of record appearance to match the prime key. Updating that table screws up the order again.

This is why you NEVER use a table directly when you have a sorting issue. You ALWAYS use a query.