Page Headers for Columns

[jparker1954]

I'm using Access 2003. I have a report that I've set up with 2 columns. Unfortunately the Page Header won't print the headings for both columns. I looked on the Help screen and it says the information below. I assume this does not apply to the Page Header section? When I try to use a group header, all I can get is a header for every single row in the group. Any suggestions besides - get with the 21st century and upgrade - which is not going to happen? What am I doing wrong?

Repeat a group header in another column

• Open the report in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
• Double-click the section selector (section selector: The box on the left side of a section bar when an object is open in Design view. Use the box to perform section-level operations, such as selecting the section.) of the group header (group header: Used to place information, such as group name or group total, at the beginning of a group of records.) to display the property sheet.
• Set the RepeatSection property to Yes.

[jparker1954]

I did finally get it to work by setting the group interval to 500, but if there's another way, feel free to let me know!

[June7]

The only way I have been able to get headings to duplicate for each column is to manually create duplicate label controls in the Page Header section and space them across the page as needed.

However, I do not have any grouping set up for the data. So I created a group based on a simple expression: "Headers" and moved one set of header labels into the group header and deleted all from Page header. Wow - this works! Did not have to set interval. How did you set interval?

[jparker1954]

Set the interval in the Sorting and Grouping Screen. When you pick a field to sort by, you set the group properties at the bottom of the box. I set Group On:Interval, and Group Interval:500. Worked in my case for the columns I'd set.

The only way I have been able to get headings to duplicate for each column is to manually create duplicate label controls in the Page Header section and space them across the page as needed.

However, I do not have any grouping set up for the data. So I created a group based on a simple expression: "Headers" and moved one set of header labels into the group header and deleted all from Page header. Wow - this works! Did not have to set interval. How did you set interval?

[June7]

Thanks for the tip. The interval property shows only with a number type. Once I added a group in the report, the RecordSource ORDER BY no longer worked and had to add a sort criteria. My sort field is a text type.

[jparker1954]

I sorted my list based on an ID number for each row.

Thanks for the tip. The interval property shows only with a number type. Once I added a group in the report, the RecordSource ORDER BY no longer worked and had to add a sort criteria. My sort field is a text type.

[June7]

My point is, the interval setting was not available and I didn't need it anyway. My data all fits on 1 page with 2 columns. Maybe I would have an issue if the data spanned multiple pages.