February 22, 200520 yr This one is killing me because it is so simple but I am having erious brain blockage.... Basically looking to write a script / calculation that does the following. If (Field name) starts with "UL" then (Client) = "Ultra" If not then "Unknown" Here is my current entry that is not working correctly. If (Field name=Left ("UL"; 2) ; "Ultra" ; "Unknown" ) Someone please save my brain from the fog it is in. thanks Brad
Create an account or sign in to comment