(IIF(OR Statement? 1

[sidetracked]

I can't get this to work?

=IIf(OR([Sub Name]="DEMO",([Sub Name 2]="DEMO"),0,[SUB 2 $]))

is my or statement wrong?

MCSE 2K - MCSA 2K - NET+ - A+

Paul..

 

[ByteMyzer]

Access doesn't use the And() and Or() expressions the way Excel does. The correct syntax for the above expression for Access should be:
[tt]
=IIf([Sub Name]="DEMO" Or [Sub Name 2]="DEMO",0,[SUB 2 $])
[/tt]

 

[sidetracked]

Thanks for the advise Byte

MCSE 2K - MCSA 2K - NET+ - A+

Paul..