I am trying to set my criteria for USOC.USOC_DESC using: IIf([Forms]![Set Criteria]![freDedicatedMux]=1,('<>"MULTIPLEXING"'),[tblUSOC]![USOC_DESC]); however, this does not work. Although, if I use: IIf([Forms]![Set Criteria]![freDedicatedMux]=1,"MULTIPLEXING",[tblUSOC]![USOC_DESC]) it does work, yet is not what I want being that I want only records that are NOT MULTIPLEXING.
If this is impossible for MS Access to handle, does anyone know of anything that would trick it into doing what I need?
Thanks to all that posted responses! I have determined that Access will not let you pass operators to a parameter. Therefore, I have passed the values to a nested query and it runs just fine. If you are interested in specifics let me know.