J
Jorge
i want to sort a huge table and want to keep or save it in
its sorted form, how should i do this
its sorted form, how should i do this
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
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
J
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.
L
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
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