What determines a table’s sort order? - ProProfs Discuss
Advertisement

What determines a table’s sort order?

What determines a table’s sort order?

Change Image    Delete



Asked by NOEL, Last updated: Mar 26, 2024

+ Answer
Request
Question menu
Vote up Vote down

4 Answers

John Smith

John Smith

John Smith
John Smith

Answered Apr 13, 2017

Index field
upvote 1 downvote
Reply 

NOEL

NOEL

NOEL
NOEL

Answered Nov 22, 2019

Index field determines a table's sort order


upvote downvote
Reply 

C. Bernthal

C. Bernthal

Its kind of my job to give answers

C. Bernthal
C. Bernthal, Teacher, MA, P.hD, Seattle

Answered Nov 27, 2018

In this example, you can see that the entry date is not in date order. Neither are the entries in columns C, D and E. By contrast, the Income column is determining the order. It goes from low to highest. This is the index field. It may be that another determinant could be chosen for the Index field, such as number sold. The essence is that the index field is the area of interest; i.e. what the data output is to show.

upvote downvote
Reply 

John Adney

John Adney

John Adney
John Adney

Answered May 04, 2017

Autonumber field only helps with the order in which they were created. Helps determine if something was deleted and how many records you have. However,the order of columns in a multi-column index definitely matters. One type of query may need a certain column order for the index. If you have several types of queries, you might need several indexes to help them, with columns in different orders.
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.