Expression Problem Error

[Tim]

I have the following expression in a query.

TYPE: IIf([SCHTYPE]<>'E-blast','Phone Call',[SCHTYPE])

I need to add the <>Hypo to it, but I keep getting an
error function has wrong number of arguments. WHY?

The data in SCHTYPE: The expression creates
This;
Phone Call - Inbound Phone Call
Phone Call - Outbound Phone Call
E-blast Eblast
Hypo Phone Call

So Hypo is made into a Phone call and I need it to stay
Hypo.. Help thanks..

 

[Les]

Tim,

Try the following:


TYPE: IIf([SCHTYPE]like 'Phone Call*','Phone Call',
[SCHTYPE])

 

[John Spencer (MVP)]

TYPE: IIF(SchType='Hypo' or SchType='E-Blast', SchType, 'Phone Call')

OR

TYPE: IIF(SchType IN ('Hypo','E-Blast'), SchType, 'Phone Call')

Tim,

Try the following:

TYPE: IIf([SCHTYPE]like 'Phone Call*','Phone Call',
[SCHTYPE])

-----Original Message-----
I have the following expression in a query.

TYPE: IIf([SCHTYPE]<>'E-blast','Phone Call',[SCHTYPE])

I need to add the <>Hypo to it, but I keep getting an
error function has wrong number of arguments. WHY?

The data in SCHTYPE: The expression creates
This;
Phone Call - Inbound Phone Call
Phone Call - Outbound Phone Call
E-blast Eblast
Hypo Phone Call

So Hypo is made into a Phone call and I need it to stay
Hypo.. Help thanks..

.