Simple If/Then Problem

[nnaxor]

I am having trouble with a simple If/Then statement in my database. Can you help me figure out what I am doing wrong?

 
Private Sub Red_Amt_AfterUpdate()
 
    [RBAAmt] = [RedAmt] IF [Request] = "Personal" * 0.90 Else * 0.25 END IF
End Sub

Thanks for your help, I'm sure it is something basic I just can't see it.

[ssanfu]

Please explain what your formula is supposed to do.

The syntax is:

Private Sub Red_Amt_AfterUpdate()
   IF [Request] = "Personal" THEN
     [RBAAmt] = [RedAmt] * 0.90
  Else 
     [RBAAmt] = [RedAmt]* 0.25 
  END IF
End Sub

Is this close???

[nnaxor]

I think so I'll try it - basically if a field has the word Personal in it instead of a number I need the number multiplied by 90%, if it has a number I need it multiplied by 25% - going to try your suggestion now

[ssanfu]

a field has the word Personal in it instead of a number

You do realize that a field that has "Personal" stored in it is a TEXT type field. If you store 12345 in that field, it is TEXT, not a number??

[nnaxor]

Yes I do know that but thank you in case I didn't. The numbers need to be treated as text in this case; your solution worked beautifully. Thanks so much!

[ssanfu]

You're welcome.......