How do you sort a table using VBA? 1

[christheprogrammer]

Hi all, I need to sort a LINKED table by a unique number which exists in the tables' indexes.&nbsp;&nbsp;Unfortunately, it is not the first index on the list, and therefore the table is not pre-sorted.&nbsp;&nbsp;I do not believe I can use the .index method to organize the table since it is LINKED.&nbsp;&nbsp;Any suggestions on this?<br>Thanks a bunch,<br>Chris

 

[Amiel]

Try this...<br><br><b><br>&quot;Select * from Table1, Table2 where Table1.index = Table2.Index Order By [Table1].[TheOtherIndex]&quot;<br></b><br> <p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br>