Sorting report by groups

R

RichN

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?
 
T

Tom Lake

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Grouping {MERGEFIELD} into 2 or 3 Columns 0
Possible to Combine reports to's to a single box? 0
Report - Sorting and Grouping 2
Average cases handled per agent in Sorting and Grouping report 0
Report Headers Mis-Matched from detail on report 1
Report Group Header 9
Report/Subreport Problems with Sorting/Grouping, Access 2003 2

Top