I have an access database from which I am pulling records. The main table contains all the info for a specific person and their business. I am retrieving the data and sorting based on last name, and I am also retrieving and sorting the data based on the specific region a person is in. What I would like to do is also sort based on a sector that a person’s business is a part of. I would be able to retrieve all the records for each sector and sort them just as I did with region, but I don’t want to list ALL the sub-sectors.
Example of sectors:
Education
Health and Wellness - Massage Therapy
Health and Wellness - Medical / Pharmaceutical
Health and Wellness - Physiotherapy
Home Improvement/Construction
Hospitality - Accommodations
Hospitality - Tourism
I would like to just sort by the sectors, not the sub-sectors listed after the dashes. In the example above, I would like to have the headings Education, Health and Wellness, Home Improvement/Construction, and Hospitality with all people in those specific sectors and well as the corresponding sub-sectors listed. So for Health and Wellness, for example, I want to get the records in all the sub-sectors (Massage Therapy, Medical / Pharmaceutical, Physiotherapy), but I don’t want the records to be divided into these sub sectors. I want all the records that fall into each of these sub-sectors to be listed under the heading “Health and Wellness” and sorted alphabetically.
Is this possible and can someone help?
Thanks in advance.
Example of sectors:
Education
Health and Wellness - Massage Therapy
Health and Wellness - Medical / Pharmaceutical
Health and Wellness - Physiotherapy
Home Improvement/Construction
Hospitality - Accommodations
Hospitality - Tourism
I would like to just sort by the sectors, not the sub-sectors listed after the dashes. In the example above, I would like to have the headings Education, Health and Wellness, Home Improvement/Construction, and Hospitality with all people in those specific sectors and well as the corresponding sub-sectors listed. So for Health and Wellness, for example, I want to get the records in all the sub-sectors (Massage Therapy, Medical / Pharmaceutical, Physiotherapy), but I don’t want the records to be divided into these sub sectors. I want all the records that fall into each of these sub-sectors to be listed under the heading “Health and Wellness” and sorted alphabetically.
Is this possible and can someone help?
Thanks in advance.