I want to order the following by price in ascending order, can someone show me<BR><BR>SQL="Select * From techspy Where product.product = '"&product&"' ORDER BY price"
Did you even simply TRY it????<BR><BR>The default is ascending order.<BR><BR>You add DESC to the end if you want descending, but you don't have to use anything for ascending. (You *can* use ASC, but you don't have to.)<BR><BR>