Group Header Does Not Sort Properly

[rhesus_7]

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 properly. It appeared to be just like the one shown below.

ZC-11
ZC-02
ZC-03
.
.
.
ZC-08
ZC-01
ZC-10

I used group header because there are other values which include "Ziloilo" and "Ztac". This is grouped according to the first two letters.

I hope you would help me here. Thank you!

 

[ThreeCrow]

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)".

You have told your Report to Group and sort by the first two charaters only.

Try just Grouping and Sorting by the "Primary_Key" and your result will be.


ZC-01
ZC-02
ZC-03
.
.
.
ZC-08
ZC-10
ZC-11