IIf Statement with or

[flip_33_]

In a query i have the following code which gives any record with an employee ID's starting with a P ( which are accounts payable ) the paygroup ( PAYGRP ) AP so we can seperate them...

PAYGRP: IIf(Left([EMP_ID],1)="P","AP",[PAY_GRP])

How do i edit the current code so if the employee Id starts with R, it gives them the PAYGRP AR, as well as still keeping the current operation it is performing...

 

[LTunnicliffe]

I think this is it:

PAY_GRP: IIf(Left([EMP_ID],1)="P","AP",IIf(Left([EMP_ID],1)="R","AR",[PAY_GRP]))

Hope this helps!!!