AnsweredAssumed Answered

Help sorting

Question asked by ArtKanowitz on Dec 27, 2010
Latest reply on Dec 27, 2010 by philmodjunk

Title

Help sorting

Post

I have a Medical Director Registration Database. Each MD has a record with multiple fields containing demographic items. One of the fields is their practice region. However, some of the MDs practice in more than one region so I have three separate fields for their practice regions (region1, region2, region3). Now I want to do a sort however I want to combine all the regions is a single sort.

Example:
MD_AAA     North

MD BBB     North, West, South

MD_CCC  South

MD_DDD  West, South

I want sort to look like this:

North  Region     

      MD_AAA
      MD_BBB

West Region

  MD_BBB
  MD_DDD

South Region

  MD_BBB
  MD_CCC
  MD_DDD

How do I create such a sort??

Thanks

Arthur Kanowitz MD

Outcomes