AnsweredAssumed Answered

Five separate fields to combine into one field

Question asked by NathanStrahl on Dec 23, 2011
Latest reply on Dec 26, 2011 by philmodjunk


Five separate fields to combine into one field


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


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.