Expression Help

T

tubar

Registered User.

Local time

Today, 02:40

Joined

Jul 13, 2006

Messages

190

• Oct 23, 2006

• #1

PART NUMBER: IIf([MANUFACTOR SENT]=2,[GE PART #])OR IIf([MANUFACTOR SENT]=3,[PHILLIPS PART #])OR IIf([MANUFACTOR SENT]=1,[SYLVANIA PART #])

CAN ANYONE HELP ME FIX THIS EXPRESSION

 

John Big Booty

AWF VIP

Local time

Today, 19:40

Joined

Aug 29, 2005

Messages

8,243

• Oct 23, 2006

• #2

Try this;

IIf([MANUFACTOR SENT]=2,[GE PART #], IIf([MANUFACTOR SENT]=3,[PHILLIPS PART #],[SYLVANIA PART #]))​

 

C

CEH

Curtis

Local time

Today, 02:40

Joined

Oct 22, 2004

Messages

1,187

• Oct 23, 2006

• #3

PART NUMBER: IIf([MANUFACTOR SENT]=2,[GE PART #]),IIf([MANUFACTOR SENT]=3,[PHILLIPS PART #]),IIf([MANUFACTOR SENT]=1,[SYLVANIA PART #],"IfFalse"))

That might work.......
You might look into using an "If....Then" or "Select Case" statement. With those you could also add a message box if number was not 1,2, or 3.