Report Rookie- record count

  • Thread starter Thread starter Mike Mueller
  • Start date Start date
M

Mike Mueller

I have a simple report of a roster. I just want to add the
total count of members to the footer line. I thought it
would be simple, but my Help function is being funky. How
do I access this number?

Mike
 
Create a control in the footer and make its ControlSource -
=Count(*)

PS, if you make a report with the wizard, you can choose
summarization options.
 
Pat,
Thank you for the quick response. I am still on 2000,
and I tried the wizard earlier and never got summarization
options. I also tried creating a label ans setting the
source to =Count(*) and it displays #err on the report.

Mike


message : Create a control in the footer and make its
ControlSource -
: =Count(*)
:
: PS, if you make a report with the wizard, you can choose
: summarization options.
:
: >-----Original Message-----
: >I have a simple report of a roster. I just want to add
: the
: >total count of members to the footer line. I thought it
: >would be simple, but my Help function is being funky.
: How
: >do I access this number?
: >
: >Mike
: >
: >
: >.
: >
 
I meant textbox. I did find the problem on my own via
MVPS.org and Dev Ashish's site. The control was in the page
footer. I did as he suggested by creating the control
elsewhere and setting the control in the footer to equal the
first textbox.

Mike

message : You need to create a textbox, not a label.
:
: >-----Original Message-----
: >Pat,
: > Thank you for the quick response. I am still on
: 2000,
: >and I tried the wizard earlier and never got
: summarization
: >options. I also tried creating a label ans setting the
: >source to =Count(*) and it displays #err on the report.
: >
: >Mike
: >
: >
: in
: >message : >: Create a control in the footer and make its
: >ControlSource -
: >: =Count(*)
: >:
: >: PS, if you make a report with the wizard, you can
choose
: >: summarization options.
: >:
: >: >-----Original Message-----
: >: >I have a simple report of a roster. I just want to
add
: >: the
: >: >total count of members to the footer line. I thought
: it
: >: >would be simple, but my Help function is being funky.
: >: How
: >: >do I access this number?
: >: >
: >: >Mike
: >: >
: >: >
: >: >.
: >: >
: >
: >
: >.
: >
 
Back
Top