7 Replies Latest reply on Jan 15, 2016 2:15 PM by jcondle

    I have many fields where the values are coded 0,1,2,3,etc.  the numbers/txt relate to yes, no, unknown,etc.  Should these fields be text or numeric?

    jcondle

      I have many fields that are coded with digits starting from 0.

      An example would be  field called site   with possible values 1=PGH  2=ARC 3=TOR

       

      At present that are set to text.  I was wondering if it would be better as numeric.

       

      I related question would be how to set a numeric field to only take integers.  I know I can set the format to only display integers.

       

      Joe