need to determine a text value of a field based upon a number

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Paul D (anonymous_at_discussions.microsoft.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 14:41:08 -0700

need to determine a text value of a field based upon a
number.
I have a Field AJ that contains a number 1,2,3,4,8
   If the number is 1,2,4,5,6,8,9,10 Text Value is "call
is connected"
   If the number is 3 Text Value is "call not connected"

How do I put my statement together?

Quantcast