iif statement in query
Posted on 2012-04-13
I have an Access query with the following in the criteria for one of the fields
what I am trying to do is as follows.
If the form is open show the records for teh Section_Key on the form
otherwise show all records
However the query will only the records for the form (if it is open) otherwise it shows no records.
The Section_Key is numeric so using * in the true part of the iif statement does not work.
I tried putting in >1 but this won't work either. Although if you replace the whole statement with >1 this will show all records.