Help with getting column headings to display properly

[master_chiefzor]

I am creating a report using Access 2000 for work (I work at a hospital) and I am having a problem, so let me explain what I am trying to accomplish.

I am trying to create a report that will show a list of patients whose orders expire between certain dates selected by the user. The patients are organized by doctor. I want each new doctor to start on a new page.

Currently, the report has a group header which displays the heading for the report along with the name of the doctor. Underneath the doctor name are my column headings. These are describing information such as "patient name", "birthdate", "Expiration Date" etc. This section is repeated for each new doctor on the list.

In the details section is where all of the information for the column headings
described above is located. Everything functions exactly as I'd like it to and as I described originally except for one small problem. The column headings don't repeat themselves on the second page if there are enough patients to go on to another page.

I realize that the headings could be on each page if I put them in the page header instead of the group header, but then they would be above the group header and that won't work. I was also thinking that I could put heading for the report in the report header, but then it would only be displayed on the first page, but I really need it to re-display again, once for every doctor.

If anyone knows of a setting I could change that could help me or a segment of code that would help me accomplish my goal, I would be greatly appreciated. If necessary, I could elaborate on it further, or even possibly attach the database as I have constructed it so far. Thanks in advance.

 

[WayneRyan]

Welcome Master,

If you get your report in Design View, right-click on the Group Header,
There should be an entry for "Repeat Header On Page"" or something
like that.

Wayne

 

[master_chiefzor]

Thanks for your reply.

I see a property called "repeat section" that is described as "Repeat this section at the top of each page." I believe this is the property that you were describing to me. The problem with that is, the first part of my group header I only want printed once per each group. The part that I want repeated is the column headings so that if the information goes on to the next page, they will display again there. I have a feeling they shouldn't be in the group header at all, but I'm not sure where else I could put them that would make this work properly.

Thank you for your help

 

[Rebel]

I'm pretty new at this stuff, so this might sound like a goofy work-around...
I took a report that I have that is similar to what you are describing yours is like. In the query that goes with this report I added a field that I just called "Filler." In the Sorting and Grouping section of my report I added "Filler" just under the main grouping (in your case, the Doctors) and said "yes" for group header. In this blank header I stuck my column names and put "yes" in the "repeat section" property. Finally, adding "Force New Page Before Section" to my main grouping made my report break at all the main groupings, and put the column headings at the top of each new page, but below the Main Group header.

Probably not very elegant, but try it and see if that is what you want.

 

[master_chiefzor]

Rebel,

I must say that this is quite a goofy work around, and I'm somewhat surprised that there isn't an easier way to do this. However, what you described did work *EXACTLY* how I wanted it to, so thank you VERY MUCH for pointing me in this direction. I really appreciate it.

 

[Rebel]

Hey, no problem. I'm just glad I could finally contribute something instead of just being a leech. With any luck, one of the gurus around will have an easier and more elegant solution.

 

[master_chiefzor]

Perhaps there is a more elegant solution, but as far as I'm concerned, this works fine. Thanks again!