Im trying to make my query use an IIF statement but it isn't quite working as I'd hoped. In my table, each record has a value in the last column that will either be "HA" or "HM". Im my query I am trying to make it look at a value on a form and if the value is False then show only "HM" records. If it is True then display "HM" and "HA" records.
I can get the False part to work but the true bit says it is too complex. My current code that does not work is displayed below.
IIf([forms]![fmHAMain]![txtaccessboth]="False","HM","HM" Or "HA")