2 Replies Latest reply on Dec 26, 2011 9:58 AM by philmodjunk

    Five separate fields to combine into one field

    NathanStrahl

      Title

      Five separate fields to combine into one field

      Post

      I have a medium complex database that has 5 fields that I want to combine into one field. For example:

      Now:

      Medication Field     Strength Field    Directions Field         Number of tablets Field    Number of refills Field   

          Zoloft                       100                One daily                        30                                3

       

      After combining, I want in one field:

         Zoloft 100 mg One daily 30 3

      Or even better:

         Zoloft 100 mg, Take One daily, # 30,  3 refills

       

      This is needed to view as a table

       

      As always, I could never have accomplished what I have completed without your help. Thank you again.