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.
.
.
