Converting a letter (text) to a number

  • Thread starter Thread starter Guest
  • Start date Start date
You can add an expression like this in a query cell. Just
make sure that your only values are F and M.

Sexfld:IIF(fld="F",2,1)

Otherwise, do:

Sexfld:IIF(fld="F",2,IIF(fld="M",1,0))

In this case, 0 will be anything that wasn't F or M
 
Back
Top