AnsweredAssumed Answered

ID field from data in 2 other fields

Question asked by ScottRoe on Mar 14, 2013
Latest reply on Mar 14, 2013 by philmodjunk

Title

ID field from data in 2 other fields

Post


     I have a Vendors table which has contact info for my vendors.  It includes company, address and phone information.  I am trying to create a "Vendor ID" field which will assign the ID from the first letter of the company name, followed by the last 4 digits of the primary phone number.

     Can anyone help?

      

     Thanks

Outcomes