IF in Excel VS IIF in Access

[menonoting]

Hello All:
I'm totally new in Access but I'm good with Excel this formula works for me in excel can someone tell me why it does not work in Access?

=IF(OR([First]="",[Last Name]=""),"Name Missing",
IF(AND([Middle Name]="",[Suffix]>0),[First]&" "&[Last Name]&" "&[Suffix]&"." ))

I know IF must be IIF

[alansidman]

The syntax in Access is slightly different for the "and" and "or' portion of an IIF statement. Look at this site and scroll down to the last example to see how it works.

http://www.techonthenet.com/access/f...vanced/iif.php

Alan