Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: Access - Stored Query Help
07-07-2007, 11:04 PM #1
- Join Date
- Mar 2006
- Thanked 0 Times in 0 Posts
Access - Stored Query Help
I have a page with approx 40 check boxes and one text field, i want to write an stored query that filters the records in my table by the check boxes that are checked, any unchecked check boxes would simply be ignored. How would i do this?
Many thanks for any responses and many thanks to all the people on this forum that have helped me in the past.
07-16-2007, 09:30 PM #2
- Join Date
- Dec 2002
- Arlington, Texas USA
- Thanked 11 Times in 11 Posts
A single checkbox can be looked at as being boolean it is either checked or it isn't.
in psuedocode it would be checkbox.checked
A textbox group changes this, so that now you look at the value assigned to each individual checkbox and is that checkbox value checked yes or no
psuedocode here would be checkbox.value.checked
in the database you can save this information as either a string or a yes/no value for each checkbox. If they are Yes/No you can simply write a WHERE clause for each of the checkboxes that looks to see if the value is checked (true) or Not checked(false)
That should point you in the right direction.