So I am thinking that the version of Jet I am using doesn't allow IIF stuff when there is a equal sign in there.

Funny as the version of Jet I was using in VB6 is the same version as what I am using in .NET 2010

Anybody else have an idea?