I created a group header based on the primary key. It has text as its datatype. The values for this key are alphanumeric e.g. "ZC-01". I used the groupings and sorting function which results to this "=left([Primary_Key],2)".
When I input "ZC-01" to "ZC-20", Access does not sort the list...