Results 1 to 2 of 2

Thread: Simple question

  1. #1
    Join Date
    Dec 2003

    Unhappy Unanswered: Simple question

    I need to set up a query for records based on a yes/no checkbox for a field called "Add". I only want the ones that are checked. What do I put in the criteria box for the query? Everything I have tried gives me a expression to complicated to process error message. Thanks for the help.

  2. #2
    Join Date
    Nov 2003

    Re: Simple question

    SELECT [Table].FIELD1, [Table].FIELD2, [Table].FIELD3, [Table].Add
    FROM [Table]
    WHERE ((([Table].Add)=True));

    Obviously fill in the table name and field names as appropriate.

    Hope this is what you were looking for.

Posting Permissions

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