table display

[Robert Mann]

Have a table with the following in it

2002 CR 85

2002 CR 125

2004 CR 125

2002 CR 250

 

 

And I would like to be able to display it for highest to lowest

Like this

2004 CR 125

2002 CR 250

2002 CR 125

2002 CR 85 

 

But using the following SQL 

put "SELECT Year_Model FROM yearmodelsize WHERE yearmodelsize.BID='" &
gbrandid & "' and yearmodelsize.stock_specs_complete='no' ORDER BY
Year_Model DESC" into theSQL

 

does not do this? What do I have to change with the table settings?

It displays like this

2002 CR 85

2002 CR 125

2004 CR 125

2002 CR 250

 

 

 

Thanks

Rob