Desperate

[Bland]

Increasing the size of the footer affects all of my
reports in XP. I never had this problem in 98. I don't
know what to do.

Subject: Re: Counting Revisited
From: "Duane Hookom" <duanehookom@NO_SPAMhotmail.com>
Sent: 10/31/2003 8:30:12 PM




Do all of your reports behave this way? Increasing the
size of a report
footer will have no affect on the size or number of the
detail sections.

--
Duane Hookom
MS Access MVP


message

Expanding the report footer to put the text box with the
expression associated with it seems to make the report
display only 7 items. If I leave the size of the footer
alone, I cannot put my field in there, but it doesn't
wipe out my information either.

-----Original Message-----
We need more information. Adding a control to a report footer does not
shrink a report.

--
Duane Hookom
MS Access MVP

I have two fields appearing on a query. Customer Name
and Customer Account number. I would like for a Grand
Total number of customers to appear at the bottom of the
report.

I created a text field and associated the following
expression to it: =Count([Medicaid Account #]). I

put

it


.

.

..

 

[Gary Miller]

Still need more information. Which footer are you putting
this in? There are Form, Page, and Group footers. For a
report total it should go in the Form footer. You are still
not very clear on what is growing in size. Is there dead
space? Where?

Gary Miller
Sisters, OR

Increasing the size of the footer affects all of my
reports in XP. I never had this problem in 98. I don't
know what to do.

Subject: Re: Counting Revisited
From: "Duane Hookom" <duanehookom@NO_SPAMhotmail.com>
Sent: 10/31/2003 8:30:12 PM




Do all of your reports behave this way? Increasing the
size of a report
footer will have no affect on the size or number of the
detail sections.

--
Duane Hookom
MS Access MVP


message

Expanding the report footer to put the text box with the
expression associated with it seems to make the report
display only 7 items. If I leave the size of the footer
alone, I cannot put my field in there, but it doesn't
wipe out my information either.

-----Original Message-----
We need more information. Adding a control to a report footer does not
shrink a report.

--
Duane Hookom
MS Access MVP


I have two fields appearing on a query. Customer Name
and Customer Account number. I would like for a Grand
Total number of customers to appear at the bottom of the
report.

I created a text field and associated the following
expression to it: =Count([Medicaid Account #]). I

put

it
in the report footer thinking that it would total the
whole thing. It ended up shrinking my report from 400
pages to 1 with just 7 accounts on that single page. It
did accurately count those seven accounts, but I can't
seem to get it to total the whole thing. I tried
creating a group footer and placing it in there, but that
didn't work either.

I know I am messing something up. I just can't figure
out what.


.

.

.

 

[Bland]

I don't have a form header/footer. I have a page and a
report. How do you add a page footer? I expanded the
size of the report footer and when I went to the layout,
I lost 400 pages.

-----Original Message-----
Still need more information. Which footer are you putting
this in? There are Form, Page, and Group footers. For a
report total it should go in the Form footer. You are still
not very clear on what is growing in size. Is there dead
space? Where?

Gary Miller
Sisters, OR

Increasing the size of the footer affects all of my
reports in XP. I never had this problem in 98. I don't
know what to do.

Subject: Re: Counting Revisited
From: "Duane Hookom" <duanehookom@NO_SPAMhotmail.com>
Sent: 10/31/2003 8:30:12 PM




Do all of your reports behave this way? Increasing the
size of a report
footer will have no affect on the size or number of the
detail sections.

--
Duane Hookom
MS Access MVP


message

Expanding the report footer to put the text box with the
expression associated with it seems to make the report
display only 7 items. If I leave the size of the footer
alone, I cannot put my field in there, but it doesn't
wipe out my information either.

-----Original Message-----
We need more information. Adding a control to a report
footer does not
shrink a report.

--
Duane Hookom
MS Access MVP


message
I have two fields appearing on a query. Customer Name
and Customer Account number. I would like for a Grand
Total number of customers to appear at the bottom of
the
report.

I created a text field and associated the following
expression to it: =Count([Medicaid Account #]). I put
it
in the report footer thinking that it would total the
whole thing. It ended up shrinking my report from 400
pages to 1 with just 7 accounts on that single page.
It
did accurately count those seven accounts, but I can't
seem to get it to total the whole thing. I tried
creating a group footer and placing it in there, but
that
didn't work either.

I know I am messing something up. I just can't figure
out what.


.

.

.

.

 

[Gary Miller]

Sorry, I meant Report, Page and Group footers and your total
should go in the Report Footer.

To add a page footer go to View/Page Header/Footer, same for
the Report Header/Footer. The Page footer repeats every
page, the Report Footer will appear at the very end of the
report, but above the last Page Footer.

How big did you make the report footer? We are still light
on enough details to give much help.

Gary Miller

I don't have a form header/footer. I have a page and a
report. How do you add a page footer? I expanded the
size of the report footer and when I went to the layout,
I lost 400 pages.

-----Original Message-----
Still need more information. Which footer are you putting
this in? There are Form, Page, and Group footers. For a
report total it should go in the Form footer. You are still
not very clear on what is growing in size. Is there dead
space? Where?

Gary Miller
Sisters, OR

Increasing the size of the footer affects all of my
reports in XP. I never had this problem in 98. I don't
know what to do.

Subject: Re: Counting Revisited
From: "Duane Hookom" <duanehookom@NO_SPAMhotmail.com>
Sent: 10/31/2003 8:30:12 PM




Do all of your reports behave this way? Increasing the
size of a report
footer will have no affect on the size or number of the
detail sections.

--
Duane Hookom
MS Access MVP


message

Expanding the report footer to put the text box with the
expression associated with it seems to make the report
display only 7 items. If I leave the size of the footer
alone, I cannot put my field in there, but it doesn't
wipe out my information either.

-----Original Message-----
We need more information. Adding a control to a report
footer does not
shrink a report.

--
Duane Hookom
MS Access MVP


message
I have two fields appearing on a query. Customer
Name
and Customer Account number. I would like for a
Grand
Total number of customers to appear at the bottom of
the
report.

I created a text field and associated the following
expression to it: =Count([Medicaid Account #]). I
put
it
in the report footer thinking that it would total the
whole thing. It ended up shrinking my report from
400
pages to 1 with just 7 accounts on that single page.
It
did accurately count those seven accounts, but I
can't
seem to get it to total the whole thing. I tried
creating a group footer and placing it in there, but
that
didn't work either.

I know I am messing something up. I just can't
figure
out what.


.

.




.

.

 

[Bland]

When I first create the report using the wizard, the
report footer is set at 0". It doesn't matter how big I
make it...1", 2". I even tried just clicking and
dragging it down just enough to put my field in it. The
report will still go from 400 pages to 7 accounts on one
page. Nothing I seem to do makes the accounts reappear.

-----Original Message-----
Sorry, I meant Report, Page and Group footers and your total
should go in the Report Footer.

To add a page footer go to View/Page Header/Footer, same for
the Report Header/Footer. The Page footer repeats every
page, the Report Footer will appear at the very end of the
report, but above the last Page Footer.

How big did you make the report footer? We are still light
on enough details to give much help.

Gary Miller

I don't have a form header/footer. I have a page and a
report. How do you add a page footer? I expanded the
size of the report footer and when I went to the layout,
I lost 400 pages.

-----Original Message-----
Still need more information. Which footer are you putting
this in? There are Form, Page, and Group footers. For a
report total it should go in the Form footer. You are still
not very clear on what is growing in size. Is there dead
space? Where?

Gary Miller
Sisters, OR

Increasing the size of the footer affects all of my
reports in XP. I never had this problem in 98. I don't
know what to do.

Subject: Re: Counting Revisited
From: "Duane Hookom"

Sent: 10/31/2003 8:30:12 PM




Do all of your reports behave this way? Increasing the
size of a report
footer will have no affect on the size or number of the
detail sections.

--
Duane Hookom
MS Access MVP


message

Expanding the report footer to put the text box

with
the

expression associated with it seems to make the report
display only 7 items. If I leave the size of the footer
alone, I cannot put my field in there, but it doesn't
wipe out my information either.

-----Original Message-----
We need more information. Adding a control to a report
footer does not
shrink a report.

--
Duane Hookom
MS Access MVP


message
I have two fields appearing on a query. Customer
Name
and Customer Account number. I would like for a
Grand
Total number of customers to appear at the

bottom
of

the
report.

I created a text field and associated the following
expression to it: =Count([Medicaid Account #]). I
put
it
in the report footer thinking that it would

total
the

whole thing. It ended up shrinking my report from
400
pages to 1 with just 7 accounts on that single page.
It
did accurately count those seven accounts, but I
can't
seem to get it to total the whole thing. I tried
creating a group footer and placing it in

there,
but

that
didn't work either.

I know I am messing something up. I just can't
figure
out what.


.

.




.




.

.

 

[CB]

Here is something I just discovered....

It isn't the act of making the footer bigger that is
causing the report to shrink from hundreds of accounts to
7. I created a report using the wizard, changed to
design view and then went back to preview without making
any changes in design and it still reduced the number of
accounts.

-----Original Message-----
Sorry, I meant Report, Page and Group footers and your total
should go in the Report Footer.

To add a page footer go to View/Page Header/Footer, same for
the Report Header/Footer. The Page footer repeats every
page, the Report Footer will appear at the very end of the
report, but above the last Page Footer.

How big did you make the report footer? We are still light
on enough details to give much help.

Gary Miller

I don't have a form header/footer. I have a page and a
report. How do you add a page footer? I expanded the
size of the report footer and when I went to the layout,
I lost 400 pages.

-----Original Message-----
Still need more information. Which footer are you putting
this in? There are Form, Page, and Group footers. For a
report total it should go in the Form footer. You are still
not very clear on what is growing in size. Is there dead
space? Where?

Gary Miller
Sisters, OR

Increasing the size of the footer affects all of my
reports in XP. I never had this problem in 98. I don't
know what to do.

Subject: Re: Counting Revisited
From: "Duane Hookom"

Sent: 10/31/2003 8:30:12 PM




Do all of your reports behave this way? Increasing the
size of a report
footer will have no affect on the size or number of the
detail sections.

--
Duane Hookom
MS Access MVP


message

Expanding the report footer to put the text box

with
the

expression associated with it seems to make the report
display only 7 items. If I leave the size of the footer
alone, I cannot put my field in there, but it doesn't
wipe out my information either.

-----Original Message-----
We need more information. Adding a control to a report
footer does not
shrink a report.

--
Duane Hookom
MS Access MVP


message
I have two fields appearing on a query. Customer
Name
and Customer Account number. I would like for a
Grand
Total number of customers to appear at the

bottom
of

the
report.

I created a text field and associated the following
expression to it: =Count([Medicaid Account #]). I
put
it
in the report footer thinking that it would

total
the

whole thing. It ended up shrinking my report from
400
pages to 1 with just 7 accounts on that single page.
It
did accurately count those seven accounts, but I
can't
seem to get it to total the whole thing. I tried
creating a group footer and placing it in

there,
but

that
didn't work either.

I know I am messing something up. I just can't
figure
out what.


.

.




.




.

.

 

[Gary Miller]

OK. I think that we may need to back up and do a little
process of elimination to figure out what is going on.

When you 'first create the report using the wizard" does
everything display the way you expect it to?

When you expand the report footer by 1" without putting a
control into it, what is the new behaviour?

Now when you add your control into the report footer what
effect does that have.

Send those answers back and let's figure out where to go
from what you discover.

Your line "The report will still go from 400 pages to 7
accounts on one
page." seems to be apples and oranges to me.

How many pages was it originally and how many accounts were
originally on each page?

These answers would help to giving a clue.

Gary Miller
Sisters, OR

When I first create the report using the wizard, the
report footer is set at 0". It doesn't matter how big I
make it...1", 2". I even tried just clicking and
dragging it down just enough to put my field in it. The
report will still go from 400 pages to 7 accounts on one
page. Nothing I seem to do makes the accounts reappear.

-----Original Message-----
Sorry, I meant Report, Page and Group footers and your total
should go in the Report Footer.

To add a page footer go to View/Page Header/Footer, same for
the Report Header/Footer. The Page footer repeats every
page, the Report Footer will appear at the very end of the
report, but above the last Page Footer.

How big did you make the report footer? We are still light
on enough details to give much help.

Gary Miller

I don't have a form header/footer. I have a page and a
report. How do you add a page footer? I expanded the
size of the report footer and when I went to the layout,
I lost 400 pages.
-----Original Message-----
Still need more information. Which footer are you putting
this in? There are Form, Page, and Group footers. For a
report total it should go in the Form footer. You are
still
not very clear on what is growing in size. Is there dead
space? Where?

Gary Miller
Sisters, OR

Increasing the size of the footer affects all of my
reports in XP. I never had this problem in 98. I
don't
know what to do.

Subject: Re: Counting Revisited
From: "Duane Hookom"

Sent: 10/31/2003 8:30:12 PM




Do all of your reports behave this way? Increasing the
size of a report
footer will have no affect on the size or number of the
detail sections.

--
Duane Hookom
MS Access MVP


message

Expanding the report footer to put the text box with
the
expression associated with it seems to make the
report
display only 7 items. If I leave the size of the
footer
alone, I cannot put my field in there, but it doesn't
wipe out my information either.

-----Original Message-----
We need more information. Adding a control to a
report
footer does not
shrink a report.

--
Duane Hookom
MS Access MVP


message
I have two fields appearing on a query. Customer
Name
and Customer Account number. I would like for a
Grand
Total number of customers to appear at the bottom
of
the
report.

I created a text field and associated the
following
expression to it: =Count([Medicaid Account #]). I
put
it
in the report footer thinking that it would total
the
whole thing. It ended up shrinking my report from
400
pages to 1 with just 7 accounts on that single
page.
It
did accurately count those seven accounts, but I
can't
seem to get it to total the whole thing. I tried
creating a group footer and placing it in there,
but
that
didn't work either.

I know I am messing something up. I just can't
figure
out what.


.

.




.




.

.