title: MS Access 2013: Statistics: How to encode/recode text values
body: <p>I tried to google my question, but I only get results about encryption.</p>
  
  <p>I've a big database which contains data to be used in statistics. I've many text fields which can have between 1 and 15 different values, which is encoded in numbers. (like 1=this 2=that 3=other) Is it possible in an easy way to switch between text-value and int-value? The only way I found is doing it per hundreds of IIf in a query...
  (Most statistical applications, like SPSS, provide this functionality.)</p>