I need to be able to ORDER BY two different types of information

the first ORDER BY will be permanent and will never change. The second will be based upon a variable that is sent with the page. here is my sql statement...

orderby=request("orderby")

sql1 = "select preownedlistings.* from preownedlistings WHERE lactive=1 and listexpiredate > '"&date()&"' order by listingtype DESC,'" &orderby&"';"

The query seems to work fine and they are ordered by listingtype but not by the "orderby" variable, which in this case is a make of vehicle such as Honda, Ford...etc. they are still in random order not organized at all.

any suggestions?

take out the ' around orderby variable

Thanks that worked...still having trouble trying to figure out when to use the single ' and when not to.

You use single quote(s) for text (MS Access), varchar/char (SQL Server ) and datetime (SQL Server) variables.

SELECT field1,field2.. FROM MyTable WHERE Name = 'MyName'