Microsoft Access IIf RRS feed

  • Question

  • Hey all, hopefully someone can lead me to the right direction. So there is 5 options under Operation and which ever option is selected I need the Total of the one selected going into the proper field value.  

    IIf([Operation]="S1","Total","0) I tried and no luck

    Total        Operation       AI      S1       S2       S3
    $50           S1                             $50
    $20           S3                                                   $20
    $3             S2                                       $3

    • Edited by jxdq Monday, January 1, 2018 4:00 PM
    Monday, January 1, 2018 3:59 PM