Rearrangement the data inside the Table of DB Ms Access

[Nader]

I'm using vb2005 connection to DB Ms Access.
If I have Columns in that DB it's typed Date/Time.Is it possible to rearrangement the Data(rows) in DB according the History. not by using select and using Order by History, I mean rearrangement the data inside the Table of DB...

it's mean if I have these Data

this is DB in Ms Access

A---B----C----H
ZZ---FF---GG---2/12/2008
QQ---UU---TT---1/12/2008
RR---OO---PP---3/12/2008

To make this data like this

A---B----C----H
QQ---UU---TT---1/12/2008
ZZ---FF---GG---2/12/2008
RR---OO---PP---3/12/2008

 

[mushroom]

What are you trying to achieve? Why do you need a physical arrangement of rows in your table? If you do not want to do a select and specify an order by clause. You can always make use of views. As I assume, you already know what a view is. When creating your view, specify the sorting you desire and reference your view anywhere you want to reference your original table.

 

[cjard]

I mean rearrangement the data inside the Table of DB...

No. How Access stores data is not your concern. If you want to impose ordering on rows or columns you do that at the time that you select the data