Query Help...Please

[dancat]

Hi

I am currently trying to get a query to work where I want it to be able to look at 2 field and display the results.

My Table has the fields Completed and FurtherAction, Both are tick boxes

I want the query to be able to show all work which is incomplete hence completed will = no and list brings up the list of incomplete work however, i would also like it to show the information if completed = yes and furtheraction = yes

thus the query will show all incomplete work and all work complete but further action is required.

Hope this makes sense.


Thanks

 

[Brianwarnock]

So you want the criteria to be
Where completed = FALSE Or (Completed=TRUE and FurtherAction=TRUE)
?
Brian

 

[dancat]

Yep that is correct