sorting multiple records in table

[mahlegreco]

Help?

I have been trying to sort in a table by more than one field and can't
find anyway this can be done. The find command in the Edit menu only
bounces me each time, I need to see them lined up. Also the sorting
command in the record menu only sorts in ascending and descending
order, I need to sort by specific words or pharses.

Does anybody have any suggestions????

Thanks.

 

[JohnR]

To sort by more than one field in the table do it with an
index. Open the table in design view Click on View then
Indexes. Type in a name in the first column. In the
second column select the fields from your table to sort by
in the order or the sort. In the third column indocate if
it is Ascending or Descending. i.e. LastName Ascending,
FirstName Descending.
To sort by specific words or phrases add a column and
enter the sort order for the word or phrase and sort by
that column.
Sort Order Sort Phrase Value
1 Tastes Great Old Style
1 Tastes Great Ice Cream
1 Tastes Great Beef Liver
2 Less Filling Cotton Candy
2 Less Filling Pound Cake
999 All Other Phrases Pumpkin Pie

 

[John Vinson]

Help?

I have been trying to sort in a table by more than one field and can't
find anyway this can be done. The find command in the Edit menu only
bounces me each time, I need to see them lined up. Also the sorting
command in the record menu only sorts in ascending and descending
order, I need to sort by specific words or pharses.

Does anybody have any suggestions????

Base your form on a Query, not on your table. In the Query you can
select the fields that you want sorted, left to right; specify
Ascending or Descending on each field and it will sort them, leftmost
first.

If you want to "sort by specific words" - e.g. Red sorts before Blue
sorts before Orange - you'll need to include a sortkey field in the
table containing those words, and use *it* with the Ascending or
Descending in your query.

 

[John Vinson]

To sort by more than one field in the table do it with an
index. Open the table in design view Click on View then
Indexes. Type in a name in the first column. In the
second column select the fields from your table to sort by
in the order or the sort. In the third column indocate if
it is Ascending or Descending. i.e. LastName Ascending,
FirstName Descending.

John... better check your logic here.

Having an Index on a field will indeed make sorting more efficient,
but it will not affect the order in which records are displayed. You
need to use a Query to do that. If the field or fields are indexed the
query will use the index to sort more quickly; but it will sort
correctly even without an index.