I have a challenging sorting issue I can't solve via SQL or Expression Builder. So let's say I have 'Group 1' which is the names of ten applications. Sorting this group is easy enough in access. Each system has a set of exchanges with a provider and a consumer. where it gets tricky is a secondary sort on first the name of the sending system and then a-z. see my example below:

Inventory Management System (L1)

1. Asset Management System (L2)
2. Service Management System (L2)
3. Inventory Management System (L2)
4. Computer Management System (L2)

Sorting at the "L1" level is no problem, but below that I want my first "L2" record to match the L1 record, and then after that it can be A-Z.

In the above Example, I ideally want it to look like this:

Inventory Management System (L1)

1. Inventory Management System (L2)
2. Asset Management Management System (L2)
3. Computer Management System (L2)
4. Service Management System (L2)

the logic would go something like if any L2 values are equal to an L1 value, then list those first, and anything that is not equal to the L1 value can be sorted ascending.