Hello all.
I am trying to construct a report that sorts records based on
departments in the organization.  Each department code is a letter and
a number, like B1.  However, each department is divided into
divisions, whose codes are the Departments plus another number, like
B12.  Each division has subdivisions with codes like B123.  All these
are entered into one field, "CodeID", for each employee.  I want to be
able to group the records on my report by Department, i.e., the first
2 characters in each code.  I tried using the grouping and sorting
option, setting CodeID to "Prefix Characters" and selecting "2" for
the GroupInterval, and it only half worked.  It does the grouping
right, but instead of showing B1 as the heading for that group, it
shows B123.  I don't know why it is doing this.  Thanks for any help
on this.

-George