Results 1 to 2 of 2
  1. #1
    mcahal is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jan 2012
    Location
    East Texas
    Posts
    16

    Create a report based on UNCHECKED checkboxes


    This seems like it should be so simple! I have a table with a checkbox field. Right now, nothing is checked in the table. I'd like to run a report on only the unchecked boxes. The field is titled "Located", checked box indicates yes. So, in criteria, I enter "Located"<>True. This provided a report with no records. I also tried "Located"=False. Same thing happened, like everything is checked..

    Is this not the way to create a report on this field? Thanks in advance for any advice!!

  2. #2
    mcahal is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jan 2012
    Location
    East Texas
    Posts
    16
    Good grief...I got this to work by simply putting False in the criteria. Sorry to sound so dumb!

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

Similar Threads

  1. Replies: 2
    Last Post: 11-18-2014, 08:22 AM
  2. VBA for Report Filter based on Form Checkboxes
    By Kirsti in forum Programming
    Replies: 11
    Last Post: 04-23-2014, 04:52 PM
  3. Replies: 54
    Last Post: 07-17-2013, 03:01 PM
  4. Replies: 3
    Last Post: 08-06-2012, 04:59 PM
  5. Create a report based on a pop-up form
    By p4ck3tl055 in forum Reports
    Replies: 1
    Last Post: 03-29-2010, 09:38 AM

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