Affichage des articles dont le libellé est Criteria Question. Afficher tous les articles
Affichage des articles dont le libellé est Criteria Question. Afficher tous les articles

Criteria Question

lundi 9 mars 2015

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.



I want to include all records that has the field "Field done" checked as True (This is a True/False field in the table)



I also want to include all records that have the field "Color Code" = "O", and the "Field Done" field = False.



Is this doable?



I have this so far:

IIf([Color Code]="O",False,True)



I have put this in the criteria field of the "Field Done" field on my query. However this is not working.



Help!

Criteria Question

Labels