How can I convert a letter to a number: example: F = 2 or M =1. Thank you.
L Les Jan 23, 2004 #2 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
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
