I am trying to write a very simple IIf statemnt (for the first time!) in a query. I have tested it to make sure the "or" part of the query works without the IIf statement and it comes back with the correct data. However when I put it in the IIf statement it doesn't work. If I have one condition and don't use or it works. Please help.
IIf([Forms]![frmMarketingAnalysis]![optCurrentCust]=True,"New Customer" Or "Existing Customer")