Can I suppress repeat headers across a column?

[Guest]

I've posted this question but can't find my post. I have a report with three
columns and have the headers set to repeat on each page of the report. The
problem is I don't want the headers to reapeat across every column, only the
first one.

This is how the report looks now:

Jones County Jones County Jones County
Member 1 Member 4 Member 7
Member 2 Member 5 Member 8
Member 3 Member 6 Member 9

This is how I would like for it to look:

Jones County
Member 1 Member 4 Member 7
Member 2 Member 5 Member 8
Member 3 Member 6 Member 9

Is this possible?

 

[BruceM]

In report design view, click File > Page Setup. Click the columns tab, and
select Down, Then Across. Place a text box bound to the column heading
field into the page header. That is, if Jones County is from a field in the
record, bind a text box in the page header to that field.
This will work with a report. However, with a subreport you do not have the
option of going down, then across (unless they finally fixed that in Access
2002 or 2003) unless you do an elaborate workaround that I have not tried.
In any case, you can put Jones County into the page header so that it
appears only once on every page.

 

[Guest]

These are group headers I have in the report. So in essence, the county name
may change for the next page. The columns are set to read Down, then Across.

 

[BruceM]

So put the county name field into the group header. Set the Force New Page
property of the group header as needed to ensure each county starts on a new
page.

 

[Guest]

Perhaps I am not communicating my issue clearly. Let me reiterate. I have a
report that lists all the providers in different counties within the state.
The counties are set to be group headers since many providers can be in one
county. The group footer is set to force a new page after every section to
ensure the information for that particular provider is only present on that
page.

Since the report has columns, I don't want the name of the county to be seen
atop every column on the report...only the first column. Does that make
sense?

So, is it possible to have the county repeat on every page, but not across
every column on the page?

 

[Guest]

Disregard my previous post. Putting the county name in the page header fixed
the problem. Thanks.
--
If you never attempt anything, you will never make any mistakes...thus never
enjoying the fruits of accomplishment.


:

In report design view, click File > Page Setup. Click the columns tab,
and select Down, Then Across. Place a text box bound to the column heading
field into the page header. That is, if Jones County is from a field in the
record, bind a text box in the page header to that field.
This will work with a report. However, with a subreport you do not have the
option of going down, then across (unless they finally fixed that in

Access 2002 or 2003) unless you do an elaborate workaround that I have not
tried.
In any case, you can put Jones County into the page header so that it
appears only once on every page.