Numbers * Case ( Code = "A" ; 100 ;
Code = "B" ; 125 ;
Code = "C" ; 134 ;
Code = "D" ; 346 )
You can also set up a table of code letters and their values. This table can replace the custom values value list as your list of values and you can then set up a relationship matching a code field in your main table to a code table in your look up table to use to match a code to a value in this calculation. This is how a typical invoice solution multiplies a quantity times a unit price that is looked up from a products table when the user specifies a ProductID (your "code" ).
Thank you very very much! You helped a lot! Thank you again!