Thanks Jason!!

>Instead of using nested IIFs sue the IN clause.


>SELECT phone.Name, phone.calldate, phone.phonenumber, (IIf(Left([phonenumber],3)="813","Tampa","Unknown")) AS Area
FROM phone
WHERE
Left([phonenumber],3) IN ('813','815','827');