Help with Iif statement

[tmcrouse]

I have a table that has decrease column, termed column and hsetop column. the layout looks as such

decrease termed hsetop
-125 124 -1
-14 102 88
-19 178 159

etc etc.

the first line is correct but the other two are not and I want to put in an if query on the termed column that says if the hsetop is >0 then copy whatever is in the decrease column over to the termed column so my SQL right now looks like this: (select statement right now will chng to update once I figure code)

select decrease, termed, hsetop from decreaseaug10 where
(((termed)=iif([hsetop]<0,"([decrease])")));

my error just says data type mismatch in criteria expression

[tmcrouse]

update termed=[decrease] where (([hsetop[).0);

[weekend00]

You did get it. except you have some typos and you did not post the whole query.