Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    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.

  2. #2
    Senior Coder
    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts