Hi,
I have created two menu list, one is Region and other one is Price. its working fine..Problem is...I don't know how to select my whole culunm from the database, if I select Any Region, and Any Price, that should come up with whole total database result, isn't it?
I set the Price one Any Price which value is 0.....and I don't know what value should be in Region..for the Any Region.

And also there is another problem encountered, if I select one price, one region it come up with correct result, eg: 50 records, at the bottom I have Record Paging, when I click on next record, it come with error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Price 0 AND Region='null''.
/result.asp, line 27

Current is Region default value is null, and Price default value is 0

Please suggest me what should I do.
I will be helpful.
Thanks

Mashkur