Sorting report by groups

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a set of data I want to show in a report.

The data are items like "MEA01, MEA02, MES01, MES02, MPP01, MPP02, MVV01,
MVV02".

How do I set this up in "Grouping and Sorting" (or wherever) so that the
report breaks the data down into groups, like this: (in other words, so that
items which have the first 3 letters the same, are grouped together)

MEA01
MEA02

MES01
MES02

MPP01
MPP02

etc?
 
RichN said:
I have a set of data I want to show in a report.

The data are items like "MEA01, MEA02, MES01, MES02, MPP01, MPP02, MVV01,
MVV02".

How do I set this up in "Grouping and Sorting" (or wherever) so that the
report breaks the data down into groups, like this: (in other words, so
that
items which have the first 3 letters the same, are grouped together)

MEA01
MEA02

MES01
MES02

MPP01
MPP02
Click to expand...

You can specify the number of characters on which to group. It's an option
in the Sorting and Grouping menu/

Tom Lake
 
Back
Top