Counting Problem

  • Thread starter Thread starter CB
  • Start date Start date
C

CB

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.
 
We need more information. Adding a control to a report footer does not
shrink a report.
 
Expanding the report footer to put the text box with the
expression associated with it seems to make the report
display only 7 items.
-----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.
Click to expand...


.
Click to expand...
 
Are you viewing all the pages?

--
Duane Hookom
MS Access MVP


CB said:
Expanding the report footer to put the text box with the
expression associated with it seems to make the report
display only 7 items.
-----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.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top