Results 1 to 2 of 2
  1. #1
    KingOf206 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2013
    Location
    Seattle
    Posts
    153

    Run a Query based on records that have "checked" check boxes

    I am trying to create a query (In Design View) in which I can return all the records that have a check box in certain fields. Here is a pic of my table that has my check boxes:



    Click image for larger version. 

Name:	Untitled.jpg 
Views:	9 
Size:	185.3 KB 
ID:	21450

    How can I create this query to only pull all records that have a check box (doesn't matter which one, I just want to pull all records that have a check box in any of the fields) which is "true"

    I have tried to put in "true" in the "or" row but it is not working.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    You put the parameters on different OR lines - like stair steps?

    From the displayed data, should return 6 records?

    What does 'not working' mean - wrong results? What are the results?

    If there criteria on any of the other data?

    Post the query SQL statement.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-06-2015, 02:11 PM
  2. Replies: 3
    Last Post: 04-22-2013, 06:08 AM
  3. Replies: 8
    Last Post: 03-05-2013, 01:20 PM
  4. Replies: 2
    Last Post: 07-31-2012, 09:14 AM
  5. Replies: 3
    Last Post: 11-15-2011, 02:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums