I am not using numeracy formatting in my database so prices are entered such as 350000 etc

I have a recordset on my page where I want to filter the amount to be less than $250,000
but when you view the results, the millions appear as well.

Filter -
price less than entered value of 250000

works perfectly except for the millions being seven digits


I also order all my recordsets by price asc and the million prices appear first!


Thanks

Assuming that your column for price is a numerical datatype, then this should work.

"SELECT * FROM PRODUCTS WHERE P_PRICE <= 250000 ORDER BY P_PRICE DESC;"

PRODUCTS is the table that has your price column in it.
P_PRICE is the column inside the table that stores the price, Must be numerical datatype!!!

SELECT *
FROM for_sale
WHERE Price <=250000
ORDER BY Price DESC

Is what I have an got a mismatch in criteria expression.

I tried changing the database field to number in data type and that worked.

thanks for the help anyway!

sorry - you said that!

Dim srtPriceRange
strPriceRange = Request.Form("FieldName")

SELECT * FROM for_sale WHERE UnitPrice = " + Replace(strPriceRange, "'", "''") + ""

SELECT * FROM for_sale WHERE UnitPrice < 250000"

The above example should work. Also try using Distinct or Filter