4 Replies Latest reply on Feb 17, 2016 5:56 AM by RyanAshton

    Concatenate two fields


      I have an "Estimates" table and database


      There are two fields that I need to concatenate:


      1) 4-letter invoice prefix e.g. "HKDJ"

      2) Invoice numbers e.g. "0234", "0235", etc....


      Will I need to create a new field where these two are concatenated?


      How do I concatenate?