How do I write a IFF statement to return data? I am trying to write a IIF statement to let a student know if they are approved or not approved to play a sport. Here's the statement:
Status: IIF([Waiver]="Yes"]) and IIF([Academic]="Yes"), "Approved", "Not Approved"
When I do this and hit run, it pops up with a parameter and isn't working correctly. Status is a new column not associated with any other field names but I need it to show Approved and Not Approved. It only comes up with parameter question and isn't displaying what I need to do.
Can someone please help me with this?
February 12, 2013 9:23 PM
February 13, 2013 1:28 PM