Jump to content

Accountability

Caspio Ninja
  • Posts

    78
  • Joined

  • Last visited

Everything posted by Accountability

  1. 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. From: Field 1) Price: $12.50 (will be grabbing intiger only .. disregarding any .50) Field 2) Percentage: 15% Field 3) Date: 01/14/2012 Desired Result: [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 !
×
×
  • Create New...