Combining multiple IIf to one

[ragsgold]

Hi All,



I would like to combine multiple IIf to one . below is the situation.

I have two colums Batch and Created user. Batch contains information regarding the module from which a transaction processed example AP,AR,CR,etc and when its through these subledger system the Createduser is blank. Now there are exceptions where the created user could be blank and that the reason i have to write this expression. When this crieteria matches i want to write "SYSTEM" in those blanks.

instead of writing an Iff statement like If batch="AP",if bacth =AR, so on and so forth can i write an statement like

IIF([Batch] Like IN(AR,AP,CR) And iif([CreatedUSER] ="","System",[Createduser]

basically i am saying if the crieteria of Batch = to those specific AP,AR,CR etc and if the created USER field is blank then input populate the word "SYSTEM" else populate the actual createuser field data.

[June7]

The IN operator will work only in query, not in conditional code.

Why not just:

Nz([CreatedUSER], "System")

[ragsgold]

The IN operator will work only in query, not in conditional code.

Why not just:

Nz([CreatedUSER], "System")

now that will update all blanks in Createduser with the word system i also want to fulfill another condition of field BATCh is equal to values AP,AR,CR. both must be true

[June7]

IIf((Batch="AR" Or Batch="AP" Or Batch="CR") AND IsNull(CreatedUSER), "SYSTEM", CreatedUser)

[ragsgold]

IIf((Batch="AR" Or Batch="AP" Or Batch="CR") AND IsNull(CreatedUSER), "SYSTEM", CreatedUser)

Hi June7 this worked with a little tweak
IIf(([JEreftrim]="AR" Or [JEreftrim]="AP" Or [JEreftrim]="CR" Or [JEreftrim]="IM" Or [JEreftrim]="SC" Or [JEreftrim]="SM") And ([crusrtrim]=""),"SYSTEM",[crusrtrim])

i replaced the isnull to ([crusrtrim]="") where crusrtrim is created user then it worked. for some reason it returned with SYSTEM populated for all irrespective whether it was AP,AR etc. but a little tweak did work. Thanks again for your help.