Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Unanswered: Filtering Yes/No table fields

    My table has yes/no checkbox fields and I want to create a report displaying only the checked fields.

    Any ideas how I can do this.


  2. #2
    Join Date
    Jul 2004
    There are so many ways to do it, depending on what method you use. Assuming that the report is bound to a query, you can specify True, Yes, or -1 on the checkbox's query grid. Another way would be is to put on the Report's filter property the following line: ((([Checkbox]) = -1)). Using numbers are the surest way. -1 = True or Yes and 0 = False.

Posting Permissions

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