mattnoble Posted July 28, 2007 Share Posted July 28, 2007 Ok so here's the deal. I've been trying to figure out how to go about this for a while and I just can't make sense out of it. I'm going to have a form with a bunch of checkbox options that will pertain to values in a database. Lets say I have A, B, C, D, E, and F options on the form. Each record in the database will have a field that pertains to these values. If the user selects the A, B, C, and D options I want the query to select any record that has at MOST the combination A, B, C, and D. By at most I mean I want it to pull entries that also have just [A and B], or [A, B, and C], or so on, but NONE that have more than E or F. I was just wondering if anyone could help me out. I appreciate it. Quote Link to comment Share on other sites More sharing options...
MatMel Posted July 28, 2007 Share Posted July 28, 2007 A WHERE clause like this will do: SELECT .... WHERE E = false AND F = false AND any_other_not_selected_checkbox = false Quote Link to comment Share on other sites More sharing options...
mattnoble Posted July 28, 2007 Author Share Posted July 28, 2007 Awesome, obviously I didn't even think about that . Thank you very much! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.