 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / January 2004Secondary Sorting in a table
How do you define a sort order in a master table? I.E. I have a large table that lists candidates with numerous fields. I candidates to be listed by last name, then all candidates with the same last name to be sorted by first name. The sort order would update each time a new candidate is entered. You can either use a query. If you open your table and click the Records Menu and do an advanced filter/sort it will take you to a new query. Or, try this.... highlight the two columns at the same time and click Records > Sort > Sort (asc/desc) >-----Original Message----- >How do you define a sort order in a master table? I.E. I [quoted text clipped - 4 lines] >candidate is entered. >. > I candidates to be listed by last name, then all > candidates with the same last name to be sorted by first > name. Put a sort in the query SELECT .... FROM Master ORDER BY LastName, FirstName or just set the options in the query design grid. There is a hint in the question, although I am sure that I am mistaken, that you are actually using the table datasheet to edit records; but this is such a cruel and nasty thing to do to your users it cannot be true. I am certain that you are using a form based on a query, which can be easily sorted as above. Best wishes Tim F mbergman, Data in tables are not sorted. Generally there is no need to do so, as in normal usage of a database, no-one ever sees the table anyway. You can abtain a dataset sorted in the way you want, for your purposes on form or report, by applying sorting in a query based on the table. - Steve Schapel, Microsoft Access MVP >How do you define a sort order in a master table? I.E. I >have a large table that lists candidates with numerous >fields. I candidates to be listed by last name, then all >candidates with the same last name to be sorted by first >name. The sort order would update each time a new >candidate is entered. >How do you define a sort order in a master table? I.E. I >have a large table that lists candidates with numerous >fields. I candidates to be listed by last name, then all >candidates with the same last name to be sorted by first >name. The sort order would update each time a new >candidate is entered. You don't. A Table is an unordered "bag" of data. Access will store the records wherever there is room on disk. If you want to see the candidates in alphabetical order, use a Query based on the table, sorted by last name, first name, and any other desired sort fields. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.