I would like to create a field that is populated with letters that are the result of numbers in other fields. I would like to accomplish the following.
Field 1) Price: $12.50 (will be grabbing intiger only .. disregarding any .50)
Field 2) Percentage: 15%
Field 3) Date: 01/14/2012
[based on conversion table 1=A, B=2,C=3,D=4,E=5 etc.]
Field 4) AB-AE-AL (AB=12 from field 1, AE = 15 from field 2 and AL = 112 (month/year) from field 3.
I want to get the desired values from fields 1,2,and 3 then convert those values, cancntenate and insert into field 4 (with a "-" between values).
Would appreciate any help. Thanks !