On Fri, 2 Apr 2010 19:17:01 -0700, Rhonda
wrote:

I am doing a if then statement in Access with multiple like statements. I
think I am close, but I am getting a circular reference error...

here my query
1YTDDEPRAMT: IIf([ASSETCLASSID] Like
"*-CR",[1YTDDEPRAMT]*-1,IIf([ASSETCLASSID] Like
"*DEPLOYC",[1YTDDEPRAMT]*-1,IIf([ASSETCLASSID] Like
"*BASIC-C",[1YTDDEPRAMT]*-1,[1YTDDEPRAMT])))


You're trying to set the value of 1YTDDEPRAMT based on the value of
1YTDDEPRAMT.

You cannot define a value based on itself.

Use a different fieldname before the colon.

--

John W. Vinson JVinson *at* Wysard Of Info *dot* com