I have a menu list where the user can choose as many selections as they choose. How do I write a sql statement to show records based on the selections in the menu list? I have to think there is a simpler way than writing if/thens for 16 different options.

Thanks!
Barb
<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>


<pre id=code><font face=courier size=2 id=code>strSQL = "select * from guests where initials = '" & Session("UID" & "' and show = '1' " & dtRange & " order by " & sortField & ""
</font id=code></pre id=code>