you could create a range option, so you could get the high and low price and return all items inside that range.
you could allow the user to enter the values in a delimited way...say with commas between value, and then you could add a comma to the front and back of the string (,100,110,200,400,) and compare the values using an instr() statement like:
instr({?parameter}, ","+{table.field}+",") > 0
in the filter formulas (if it is true, the row is kept else it is discarded).
or you could make a more free form method and parse it if you are using stored procs (100, 200-400, 150).
Hope one of these ideas will lead you to your solution.
IP Logged
