sorting

[Jorge]

i want to sort a huge table and want to keep or save it in
its sorted form, how should i do this

 

[Jim Carlock]

1) Create a link to the table.
2) Create a select query that uses the link.
3) Make sure the select query gets the data you want.
4) Convert the select query to a make table query.

NOTE: make sure the the name of the link is something like:
linkTable and that the table being created is named something
like tTable. That way you won't accidently erase anything
important. The names are very important in order to prevent
erasing things.

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


i want to sort a huge table and want to keep or save it in
its sorted form, how should i do this

 

[John Vinson]

i want to sort a huge table and want to keep or save it in
its sorted form, how should i do this

You don't, and you can't.

A Table is an unordered "bag" of data. If you want to see the data in
a particular order you must - no option! - use a Query sorting it by
the desired fields. If the fields are properly indexed this process
will still be reasonably efficient.

 

[Larry Daugherty]

Hi Jorge,

If you are directly viewing data in tables then you're going about it wrong.
If the time to sort is the issue then you could achieve your purpose in a
couple of different ways: via a query that opens early in your application
and stays open: by using a Sorted table which will go out of synch as the
data in the original table changes - as the application opens, run a delete
query on table Sorted and follow that with an Update query that copies all
of the records from the original table in sort order. I'm sure there are
other ways ...

HTH