Microsoft Access IIf

• Question

• 

  

  0

  Sign in to vote

  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