table display

[Bart Pietercil]

And your table schema is what exactly ?

Bart

On 5-mei-07, at 15:27, Robert Mann wrote:

> 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
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina