Hey everyone,
I have a checkbox on a form. I want to have the query return everything (*) if the box is checked, and return everything except a value ("Completed" in this case. I can get it to return everything or only fields that are "completed" but not the other way around. I've tried "<>", "!=", "Not = " and many other variations with no luck. What syntax am I missing?
Working for = completed (Query Builder)
Code:
Like IIf([forms]![frmMain]![cbCompleted]=False,"*","Completed")
Working for = completed (SQL)
Code:
WHERE ((tblTrainingRecords.Status) Like IIf([forms]![frmMain]![cbCompleted]=False,"*","Completed"))