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

    Concatenate two fields

    RyanAshton

      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?