Hello,
I am trying to use an IFF statement in a query. Basically, I have a column with the following:
TYPE
Elementary School
High School
Grocery Store
Gamestop
Gamestop
High School
Grocery Store.
The column has a lookup field where the only options are Elementary School, High School, Grocery Store, and Gamestop
I added this to a new query column RevisedType: IIf([Type]="Elementary School","Elementary")
The IFF statement removes "Elementary School" and replaces it with just "Elementary". This is exactly what I want. However, when I run the query, High School, Grocery Store, and Gamestop do not appear in the ReviseType column. Any ideas why?