access database - vb front end data not in order

[Dapper]

I have a database with an AUTONUM.

When i retreive the data its not in order. like 1 2 3 4
it like 1 2 4 3

I would like this to be in order please could you advise many thanks.

Dapper

 

[fredericofonseca]

look at using the "order by" statement on your sql statement

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Dapper]

thank for that, i knew that one just wondered if there was another way.

thanks for the help though.

dapper

 

[bmdb]

Well IMHO the "order by" would be best but if you just want the data to display in the sorted order you could just sort the output in the listbox, listview or whatever your using to display the output. An obvious alternative but it is another way to do it.