I'm having some problems with my access query. I have an if statement, but can't seem to incorporate an OR statement to work properly. Or even the wildcards.
I have my table with my information, including a field called [Pro_Status]. From this field, I want to create an if statement; if Active or Program Active, then display "yes".
I have the following code, which works great for just one of the options (either "active" or "program active":
Code:
Active: IIf([Pro_Status]="Active","Yes"," ")
I've tried to create an OR statement:
Code:
Active: IIf([Pro_Status]="Active" OR "Program Active","Yes"," ")
And had nothing happen. I've also tried to incorportate wildcards("*Active") and ("%Active") and couldn't get any of them to work. Does anyone have advice about this? How can I make this if statement work?
Thank you!!