I need help figuring out an iif function..

[kduznetsov]

This is for a school project, basically what I have a field named Zone. When this is updated with either A, B, or C I need another field in this table named revenue to display a certain number. What is the forumla to do this?

[orange]

What have you tried?
What do you think the logic for this process is?

We are not here to do the schoolwork, just to help with some direction.

Have you tried something like this?

If Zone is x1 Then
do whatever
ElseIf Zone is X2 then...

...EndIf

Or google search "ms access iif sample" to find this
http://office.microsoft.com/en-us/ac...001116100.aspx

Good luck with your project.