expression contains invalid syntax (filtering for "IN")

[Robert Blackwell]

I'm trying to find out how many contacts we have per state so I'm just
filtering in the state field and entering each states abbrieviation. This
strange thing happens when I try to filter for "IN" it says:

(!) The expression you entered contains invalid syntax.
You may have entered a comma without a preceding value or identifier.

So far I've been able to do this with everyother state I've tried. Whats
gives?

 

[Pieter Wijnen]

IN is a Reserved word that can be Used in the Filter - Place it in Quotes or
ask them to change the name of the state ;-)
ie
Type 'IN' or "IN"
HTH

Pieter

 

[Robert Blackwell]

I ended up doing I*N hehe