G
Guest
i am trying to create an if then statement on a form using the statement in
the control field below... I have a total of 7 workcenters i need to use.
What am i doing wrong? ( I can not program effectivly so browsed the forums
and found this formula and am trying to adapt it to my use.)
=IIf(([WORK CENTER]="ATC","ATC"),IIf([WORK CENTER]="OE20","Comms"),IIf([WORK
CENTER]="OE30","Comms"))
The only one that works is OE30
ATC should = ATC
OE20 = Comms
OE30 = Comms
OE40 = Radar
and so on
the control field below... I have a total of 7 workcenters i need to use.
What am i doing wrong? ( I can not program effectivly so browsed the forums
and found this formula and am trying to adapt it to my use.)
=IIf(([WORK CENTER]="ATC","ATC"),IIf([WORK CENTER]="OE20","Comms"),IIf([WORK
CENTER]="OE30","Comms"))
The only one that works is OE30
ATC should = ATC
OE20 = Comms
OE30 = Comms
OE40 = Radar
and so on