Recent content by PLS1390

JHB, I eliminated all the other criteria and used both your string and the string that pr2-eugin suggested. The query brings back all records instead of the intended results. Here is the way it was originally set up. WHERE ((([Survey Schedule].[Field done])=True) AND (([Survey...

JHB, thanks for the response. I am not sure I am fully understanding your comment. I don't think I am including this in the correct syntax. I have tried many iterations but none do what I need. My query field looks like this: WHERE ((([Survey Schedule].[Field done])=True) OR [Survey...

In General: I have a form that is to display records from my table based on if a certain field has been checked True. However, I have one situation in which I want to include a record in this form based on the value of a second field when the first field is false. In other words: I want to...