order by not behaving the way i expect

[gtbikerider]

I have records in the db (Access) eg 1, 2, 15, 21. When I "order by" in the SQL statement

instead of getting 1,2,15,21
I actually get 1,15,2,21

Why is is not ordering the way I expect? --
John Carratt

http://www.redleaf.co.uk

 

[calista]

Make sure your field in the database is a numeric type, not text. Calista :-X
Jedi Knight,
Champion of the Force