AnsweredAssumed Answered

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?

Question asked by jcondle on Jan 15, 2016
Latest reply on Jan 15, 2016 by 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

Outcomes