View Single Post
 
Old June 12th, 2008, 04:00 AM
hewstone999 hewstone999 is offline
Authorized User
 
Join Date: Feb 2008
Location: , , .
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to hewstone999
Default SORTING an table

I currently have this data in the "tbl_Infor" Tbale

Tlb_name RowNo Comments
----------------------------------------
MPI 1 Username
MPI 2 Forename
MPI 5 Date
MPI 3 ****
MPI 4 Address
LRD 1 Car
LRD 4 Year
LRD 2 Make
LRD 3 Colour
LRD 5 MODS
LRD 6 TAX DATE


I need a sort function in vba or an SQL statement that will sort the table in order of row number (See below)

Tlb_name RowNo Comments
----------------------------------------
MPI 1 Username
MPI 2 Forename
MPI 3 ****
MPI 4 Address
MPI 5 Date
LRD 1 Car
LRD 2 Make
LRD 3 Colour
LRD 4 Year
LRD 5 MODS
LRD 6 TAX DATE


Any ideas on how this can be done thanks.