Can I do this?

The subreport for the footer works just fine on its own.
But I got the multiple columns via "page setup", which I suspect is what is
messing me up now.

Many thanks if you can help me.

Your question does not explain what you are trying to do.

Give us an explanation.

--
Rick B



"r. howell" <(E-Mail Removed)> wrote in message
news:1EEC2A0A-A893-470A-96CF-(E-Mail Removed)...
> Can I do this?
>
> The subreport for the footer works just fine on its own.
> But I got the multiple columns via "page setup", which I suspect is what
is
> messing me up now.
>
> Many thanks if you can help me.

r. howell wrote:
>The subreport for the footer works just fine on its own.
>But I got the multiple columns via "page setup", which I suspect is what is
>messing me up now.


You can make the report as wide as the paper less margins bu
using the File - Page Setup - Columns menu item. Just
uncheck the Same as Detail check box and specify the column
width manually.

--
Marsh
MVP [MS Access]

I have a report which needs to have a footer which contains the name,
specialty, and address of our company, and then, parallel to our company on
the same lines the same information for each of the consultants on the job.
If I can figure out how to do it, it ought to be centered, so that if there
are no consultants, our firm's information is centered at the bottom of the
page, but if there are two consultants they should be spread out across the
bottom.

This is currently being done manually in a word processing program.

I am trying to automate things so that once the necessary information is
entered into the database, the requisite form can be created withthe push of
a button.


"Rick B" wrote:

> Your question does not explain what you are trying to do.
>
> Give us an explanation.
>
> --
> Rick B
>
>
>
> "r. howell" <(E-Mail Removed)> wrote in message
> news:1EEC2A0A-A893-470A-96CF-(E-Mail Removed)...
> > Can I do this?
> >
> > The subreport for the footer works just fine on its own.
> > But I got the multiple columns via "page setup", which I suspect is what
> is
> > messing me up now.
> >
> > Many thanks if you can help me.
>
>
>

I must be doing something wrong, but that gets me a three column report, even
though the "same as detail" box has been unchecked.

"Marshall Barton" wrote:

> r. howell wrote:
> >The subreport for the footer works just fine on its own.
> >But I got the multiple columns via "page setup", which I suspect is what is
> >messing me up now.
>
>
> You can make the report as wide as the paper less margins bu
> using the File - Page Setup - Columns menu item. Just
> uncheck the Same as Detail check box and specify the column
> width manually.
>
> --
> Marsh
> MVP [MS Access]
>

r. howell wrote:
> I must be doing something wrong, but that gets me a three column
> report, even though the "same as detail" box has been unchecked.

With that unchecked though you can go into the design of the report and make
the sections wider. It won't affect the detail section and group sections
(which will still use columns), but it will allow you to place more stuff to
the right in the report header/footer and the page header/footer.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

If I go through the report selecting the sections, and going to "Page Set-up"
and changing the width or number of columns, I seem to get whichever value I
apply last applied to the whole page.

Is there some other way to get the footer only to have more columns than the
body of the report?

"Rick Brandt" wrote:

> r. howell wrote:
> > I must be doing something wrong, but that gets me a three column
> > report, even though the "same as detail" box has been unchecked.
>
> With that unchecked though you can go into the design of the report and make
> the sections wider. It won't affect the detail section and group sections
> (which will still use columns), but it will allow you to place more stuff to
> the right in the report header/footer and the page header/footer.
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>
>
>

r. howell wrote:
> If I go through the report selecting the sections, and going to "Page
> Set-up" and changing the width or number of columns, I seem to get
> whichever value I apply last applied to the whole page.
>
> Is there some other way to get the footer only to have more columns
> than the body of the report?

Page Header/Footers and Report Heade/Footers don't support columns period.
All sections are the same width and there is only one page setup for the
report (not per section). However; unchecking the "same as detail" option
allows you to have columns that are a fixed width while you make the section
width in design view wider to accomodate having more objects in the Page and
Report Header/Footer sections.

Crude example:

This text is in the Report Header section
THIS TEXT IS IN THE PAGE HEADER SECTION
While is as
The using defined
Detail narrow in
Section columns page setup

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Aargh! We live and learn. I've learned a whole lot about queries getting
this thing so it has the right data. Now you are telling me it cannot be
formatted this way.

Any suggestions, besides telling my superiors that their standard format has
to change in this brave new world?

Do I have to try to write this as a generated Word Document?

The report is supposed to look like this

OVERALL REPORT
Lots of details

Our Company Consultant 1 Consultant 2
Architects/Planners Job Description Job Description
City, State City, State City, State

With the above 3 groups of items lining up, as they will probably not do in
discussion group formating.


Thanks

"Rick Brandt" wrote:

> r. howell wrote:
> > If I go through the report selecting the sections, and going to "Page
> > Set-up" and changing the width or number of columns, I seem to get
> > whichever value I apply last applied to the whole page.
> >
> > Is there some other way to get the footer only to have more columns
> > than the body of the report?
>
> Page Header/Footers and Report Heade/Footers don't support columns period.
> All sections are the same width and there is only one page setup for the
> report (not per section). However; unchecking the "same as detail" option
> allows you to have columns that are a fixed width while you make the section
> width in design view wider to accomodate having more objects in the Page and
> Report Header/Footer sections.
>
> Crude example:
>
> This text is in the Report Header section
> THIS TEXT IS IN THE PAGE HEADER SECTION
> While is as
> The using defined
> Detail narrow in
> Section columns page setup
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>
>
>

r. howell wrote:
> Aargh! We live and learn. I've learned a whole lot about queries
> getting this thing so it has the right data. Now you are telling me
> it cannot be formatted this way.
>
> Any suggestions, besides telling my superiors that their standard
> format has to change in this brave new world?
>
> Do I have to try to write this as a generated Word Document?
>
> The report is supposed to look like this
>
> OVERALL REPORT
> Lots of details
>
> Our Company Consultant 1
> Consultant 2 Architects/Planners Job Description
> Job Description City, State City, State
> City, State
>
> With the above 3 groups of items lining up, as they will probably not
> do in discussion group formating.

Might be able to get what you want with a sub-report. Only caveat is that
when a sub-report has columns you either have to set CanGrow on the
sub-report control to NO or use "Across, Then Down" columns instead of
"Down, Then Across".

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com