今天我它做了个商城，客户要求价格搜索，很简单就添加几个查询就可以了

Case 3:Param=Param & " And Price_Member<50 And ProIntro Like '%" & KeyWord & "%'"
 Case 4:Param=Param & " And Price_Member between 50 and 100 And ProIntro Like '%" & KeyWord & "%'"
    Case 5:Param=Param & " And Price_Member between 100 and 150 And ProIntro Like '%" & KeyWord & "%'"
 Case 6:Param=Param & " And Price_Member between 150 and 200 And ProIntro Like '%" & KeyWord & "%'"
 Case 7:Param=Param & " And Price_Member between 200 and 300 And ProIntro Like '%" & KeyWord & "%'"
 Case 8:Param=Param & " And Price_Member>300 And ProIntro Like '%" & KeyWord & "%'"