Access Query/SQL syntax

[pdevito3]

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)

Like IIf([forms]![frmMain]![cbCompleted]=False,"*","Completed")

Working for = completed (SQL)

WHERE ((tblTrainingRecords.Status) Like IIf([forms]![frmMain]![cbCompleted]=False,"*","Completed"))

[June7]

This means two queries with different criteria.

If you want everything except "Completed": WHERE Status <> "Completed"

I don't use dynamic parameterized queries. Review: http://www.allenbrowne.com/ser-62.html