expression contains invalid syntax (filtering for "IN")

  • Thread starter Robert Blackwell
  • Start date
R

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?
 
P

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
 
Top