I am trying to select the number of rooms from my database but want it so the user can select a minimum or exact number.
This is a snippet of the code on my search page
<tr><td>Number Of Bedrooms:
<td>
<SELECT NAME="REQUIREMENT">
<OPTION VALUE="AL">Minimum</OPTION>
<OPTION VALUE="EX">Exactly</OPTION>
</SELECT>
<select name="Bedrooms" size="1">
<option selected value="">-</option>
<option value="2">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select></td></tr>
This is a snippet of the code on my results page
IF Bedrooms <> "" THEN
SELECT CASE Requirement
CASE "AL" Bedrooms = Bedrooms + "and BEDROOMS >=" & BEDROOMS
CASE "EX" Bedrooms = Bedrooms + "and BEDROOMS =" & BEDROOMS
END SELECT
END IF
If Bedrooms <> "" Then
WhereClause = WhereClause & "Bedrooms = " & _
Bedrooms & " AND "
End If
Please help If you need more information please just ask i'm really strugling with this one.
Cheers