Grouping and displaying text by headers

[Cineno]

I have a table with the data organized as such:

Num Header Function
1 Places New York
2 Places Boston
3 Title Director

I would like the report to display it like this:

Places
-New York
-Boston

Title
-Director

So basically, I'm trying to come up with a report that groups the "Functions" by the same "Headers" and orders them by "Num." Does anyone know of a way to accomplish this and have it display like above? Thanks for any help!!

 

[genomon]

How familiar are you with crosstab queries? There is a crosstab wizard in the queries tab that will point you in the right direction...

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

 

[dhookom]

It looks like all you need to do is group your report by [Header] field and then order by Num. Display the header section for the [Header] field.

Duane MS Access MVP

 

[kingz2000]

Is this possible with Access 97??? I can't find a header section.

Thanks in advance for any response of help.

Kingsley

 

[genomon]

Click on View | Page Header/Footer in the menu bar.

"Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their shoes."

 

[dhookom]

If you want to display "group" headers and footers, you need to view the Sorting and Grouping dialog in your report design. This will allow you to select a field or enter an expression to group by.

Duane MS Access MVP

 

[Cineno]

I actually wrote some code to rearrange the table and now I can identify the headers by their id's. Got it working now. Thanks for the suggestions!