update query

[mws5872]

I have a fairly simplistic update query I want to create.

I figured it is best to do an IIF statement something like this.



IIf([TR by Region]![Segment]='ABF,'ABF',IIf([TR by Region]![Segment]='Mortgage','Mortgage'))

now that last part is a little tricky for me. If it does NOT match either of these values I want it to keep the field value it currently holds any ideas?

[ConneXionLost]

Based on what you've got so far in the Iif statement, as well as what you say you want it to do, you should get rid of the Iif statement altogether because you don't need one.

Cheers,

[mws5872]

I think I am confusing you... if field A contains either of these then field b needs to be over written with what is is field a( update field b) if it does not match either of these field b needs to remain the same.