problems selecting minimum when searching

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
Number Of Bedrooms:

MinimumExactly-12345

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

squirrelj

Newbie Poster

4 posts since May 2004

Reputation Points: 10

Solved Threads: 0

This article has been dead for over three months