Results 1 to 3 of 3
  1. #1

    check box help needed (2000)

    We have a form populated with multiple (49) checkboxes and need to query a table based on the checkboxes which are TRUE to find all records which match the TRUE checkboxes on the form.

    We cannot use the AND function as this checks for all the checkboxes to be true, and the OR function finds ANY checkbox that is true.


  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: check box help needed (2000)

    You haven't told us what the table looks like, but I have the uneasy feeling that it has 49 yes/no fields in it. More information please.

  3. #3
    Star Lounger
    Join Date
    Sep 2001
    SC, USA
    Thanked 0 Times in 0 Posts

    Re: check box help needed (2000)

    It sounds like you're only interested in fields with value = TRUE. If this is the case, then instead of trying to query for TRUE values, just select all records regardless of the values. Then you could base a report on the 49 fields, but in the report design use 49 text boxes, each with an IIF statement evaluating for TRUE. If the field = TRUE then display "TRUE" (or "Yes"), but if the field = FALSE display nothing ("") (quotequote). You can also have a total of the TRUE values (running sum) for each field, if you need this information. This can provide a way to view the data you're interested in (report preview), and of course you could actually print a hardcopy of data if needed. The results would never actually exist in a table, but that isn't always necessary as long as you can simply run the report to view what you need to see, and calculate totals on the report, thus providing additional statistical information.

Posting Permissions

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