http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=7079&lngWId=4

This script have a 2 box to search product from min e max value from price but in my db the field "price" is a field date in dd/mm/yyyy wat line and instruction i change?
Tks!
Very important for me!
Sorry for my english.
Sal

change "price" in line 102 and line 114 to the name of the field with the price in your database

Originally posted by Stealth
change "price" in line 102 and line 114 to the name of the field with the price in your database

The result with your modify is the show of all record if i insert in a combo min and max date. My field is not a currency but a date

yeah but why is the price a date?

the price should be a number, currency

ok!

In example script the field price have a record ii a number format (currency) in my data base the field have a record an effective date format dd/mm/aaaa.

if i want like i send you my mdb?

i know what you mean but i dont understand why?