Show either True, False or both True and False in query
In a materials table I have a Yes/No field called Reserved used to indicate if the material is reserved for a contract or not.
When looking at the inventory list, I have 3 opion buttons called Reserved, NotReserved and ShowAll. The options are given the values -1, 0 and 1 respectivly. The query runs after updating / chosing a value.
I am trying to have the query show all if the value is 1 (ShowAll). Have using the Iif function but have not succeded. The query runs OK as long as the value -1 or 0 is passed on to the query.
Anyone that can help?