iif([Animals]![pet] in ("dog","cat") doesn't understand [An

[Guest_imported]

(follow-up posting did not work. Trying a new post)

=iif([Animals]![pet] in("dog","cat&quot,[Animals]![pet],"&quot

Thanks AWithers, , but...Hrm... when I do that, then execute the report,
I get a pop-up Window:


==========================================
Enter Parameter Value

Animals: |____________________

OK CANCEL
==========================================

What's the deal? Does it not recognize the table name?
I have verified I spelled it
right.

 

[nomus1]

Try [Animals].[Pet]

 

[Guest_imported]

Thanks, but nope. same thing. I am about ready to give up.

 

[nomus1]

I tried doing the same thing - can you view your code in SQL - maybe then you could see the difference.

SELECT animals.*, IIf([animals].[pet] In ("Cat","Dog&quot,[animals].[pet],"&quot AS Expr1
FROM animals;