Invalid Procedure Call Error??

[calihiker]

Here's the sql...

What is wrong with this??

SELECT "CP" & [ID] AS [ID#], profile.Email, IIf(Mid(,Len([Email])-
2,1)=".",Right([Email],Len([Email])-(Len([Email])-2)),"&quot AS [COUNTRY
PREFIX], profile.Country
FROM profile
WHERE (((profile.Email) Like "*@*" And (profile.Email) Is Not Null) AND
((IIf(Mid([Email],Len([Email])-2,1)=".",Right([Email],Len([Email])-(Len
([Email])-2)),"&quot) Not In
("ad","at","au","be","ch","cy","cz","de","dk","ee","es","fi","fo","fr","fx"
,"gb","gl","gr","hr","hu","ie","is","it","li","lt","lu","lv","mc","nl","no"
,"nz","pt","ro","se","si","sk","uk","va","yu&quot) AND ((profile.Country) Not
In ("uk","united kingdom","United Kindom","United Kongdom","The
Netherlands","switreland","switzerland","sweden","spain","romania","Portuga
l","new
zealand","norway","Netherlands","Netherland","Nederland","Monaco","Luxembou
rg","Luxemburg","LA","Luxemburg","Lithuania","iceland","ic","Ireland","hung
ary","greece","Germany","ireland.","france","finland","España","en","Englan
d, UK","England.","england UK","england (UK)","england -
UK","england","SP","Estonia","Denmark","czech
republic","cyprus","Belgium","Austria","Australia","andorra","ad","at","au"
,"be","ch","cy","cz","de","dk","ee","es","fi","fo","fr","fx","gb","gl","gr"
,"hr","hu","ie","is","it","li","lt","lu","lv","mc","nl","no","nz","pt","ro"
,"se","si","sk","uk","va","yu&quot))
ORDER BY profile.Country DESC;

Any help would be great, thanks!!

 

[dhookom]

Before you get everyone copying and pasting and looking through your SQL, could you please tell us what if any error message you are getting? If you aren't getting an error message than tell us why you think it isn't working.

Duane
MS Access MVP

 

[calihiker]

I am getting a "Invalid Procedure Call" message when I run the query..That's it. Not sure what that means?? Don't know how else to explain it.

 

[Golom]

This expression in the "Right" call will always return -2 and that is an invalid argument in the "Right" call

Len()-(Len([Email])-2