Help needed organizing a report

[cinnie]

I have data in my form that looks like the table below.

Order Heading Name

6 Group A Mutt
3 Group B Jeff
5 Group B Laurel
4 Group B Hardy
2 Group A Fran
1 Group A Ollie

I need to produce a report that lists the names in numerical order. The
data in the 2nd column are used as headers, but they should only show when
the header changes. Like this ....

Group A
1 Ollie
2 Fran
Group B
3 Jeff
4 Hardy
5 Laurel
Group A
6 Mutt

I'd really appreciate it if someone could point me in the right direction.

cinnie

 

[Marshall Barton]

I have data in my form that looks like the table below.

Order Heading Name

6 Group A Mutt
3 Group B Jeff
5 Group B Laurel
4 Group B Hardy
2 Group A Fran
1 Group A Ollie

I need to produce a report that lists the names in numerical order. The
data in the 2nd column are used as headers, but they should only show when
the header changes. Like this ....

Group A
1 Ollie
2 Fran
Group B
3 Jeff
4 Hardy
5 Laurel
Group A
6 Mutt

Create a new report with the table as its record source.

Open the Sorting and Grouping window (View menu). In the
top row select the Heading field. Then select Yes for Group
Header in the properties below.

Select the Order field on the second row in the top section
of the window.

Now add the Header text box to the group header section and
the other fields to the detail section.

 

[Rob Parker]

PMFJI,

I don't think this gives what the OP requested. It shows all Group A,
ordered by the Order field; then all Group B ordered by the order field.

All the OP needs to do is put the Order field into the Sorting and Grouping
window, accepting the default Ascending sort. No grouping is necessary.
Set up the three text boxes to give the desired layout; set the Heading
textbox to Hide Duplicate = Yes, Can Shrink = Yes; set the Detail section
to Can Shrink = Yes.

HTH,

Rob

 

[Marshall Barton]

Your right, I missed the over all sort core part of the
question.

I never tried to shrink a HideDuplicates text box before so
I learned something new here too.

Thanks for jumping in with such an outstanding answer.

 

[cinnie]

Thanks to both Rob and Marshall. Your suggestions work well. I just don't
know what Rob means when he refers to me as the OP. Let's see...

Old Person (truer than I'd like)
Octogenarian Pariah (well...)
Offensive Prig (quite possible...)


--
cinnie

PMFJI,

I don't think this gives what the OP requested. It shows all Group A,
ordered by the Order field; then all Group B ordered by the order field.

All the OP needs to do is put the Order field into the Sorting and Grouping
window, accepting the default Ascending sort. No grouping is necessary.
Set up the three text boxes to give the desired layout; set the Heading
textbox to Hide Duplicate = Yes, Can Shrink = Yes; set the Detail section
to Can Shrink = Yes.

HTH,

Rob

 

[Marshall Barton]

Thanks to both Rob and Marshall. Your suggestions work well. I just don't
know what Rob means when he refers to me as the OP. Let's see...

Old Person (truer than I'd like)
Octogenarian Pariah (well...)
Offensive Prig (quite possible...)

More likely, it's something innocuous such as...

Original Poster