Display Count

[Rita]

I have a payroll report that displays name, gross pay, and some other
information that displays in the footer (all the detail information doesn't
display). They would like to display the total count of people. I named the
[FN LN] field Consumer in the footer. I tried =Count([Consumer]), but I just
get ERROR. Could someone tell me how to get a count? Thanks!!!

 

[Duane Hookom]

Count() should work in Report and Group Header and Footer sections, not Page
Headers and Footers.

 

[Rita]

Thanks--It does give me 1,048 for count ([FN LN]) in the header, but I need
it to display 182 and not 1,048. It's a payroll register. Nothing displays
for detail. I show [FN LN] in the ClientID Footer and Gross Pay
=sum([GrossPay]).

There are 182 Clients that display in the footer. I would like to count who
gets paid for the month--not every single pay day. [FN LN] displays in the
footer. I thought I would just name the field CONSUMER and then try
=count([Consumer]) but that gives me an error. When I used =count([FN LN])
it's totaling all the details.

Thanks!

Count() should work in Report and Group Header and Footer sections, not Page
Headers and Footers.
--
Duane Hookom
Microsoft Access MVP

I have a payroll report that displays name, gross pay, and some other
information that displays in the footer (all the detail information doesn't
display). They would like to display the total count of people. I named the
[FN LN] field Consumer in the footer. I tried =Count([Consumer]), but I just
get ERROR. Could someone tell me how to get a count? Thanks!!!

 

[Duane Hookom]

So you need to count group sections of your report. This is generally done by
adding a text box to your group footer:
Name: txtCountGroup
Control Source: =1
Running Sum: Over All
Visible: No
Then add a text box to your report footer:
Control Source: =txtCountGroup

--
Duane Hookom
Microsoft Access MVP

Thanks--It does give me 1,048 for count ([FN LN]) in the header, but I need
it to display 182 and not 1,048. It's a payroll register. Nothing displays
for detail. I show [FN LN] in the ClientID Footer and Gross Pay
=sum([GrossPay]).

There are 182 Clients that display in the footer. I would like to count who
gets paid for the month--not every single pay day. [FN LN] displays in the
footer. I thought I would just name the field CONSUMER and then try
=count([Consumer]) but that gives me an error. When I used =count([FN LN])
it's totaling all the details.

Thanks!

Count() should work in Report and Group Header and Footer sections, not Page
Headers and Footers.
--
Duane Hookom
Microsoft Access MVP

I have a payroll report that displays name, gross pay, and some other
information that displays in the footer (all the detail information doesn't
display). They would like to display the total count of people. I named the
[FN LN] field Consumer in the footer. I tried =Count([Consumer]), but I just
get ERROR. Could someone tell me how to get a count? Thanks!!!

 

[Rita]

I added the text box to the group footer and added it to the report footer.
When I run the report, I get a dialog box "Enter Parameter and then it shows
txtGroupCount??

Then I did change the text box in the footer and made it visible to see what
was going on. It is numbering correctly 1 to 182!!!!!! I don't want to see
the fun sum, I just was to see a total of 182.

Do you know what I did wrong.

Thanks so much!!!

So you need to count group sections of your report. This is generally done by
adding a text box to your group footer:
Name: txtCountGroup
Control Source: =1
Running Sum: Over All
Visible: No
Then add a text box to your report footer:
Control Source: =txtCountGroup

--
Duane Hookom
Microsoft Access MVP

Thanks--It does give me 1,048 for count ([FN LN]) in the header, but I need
it to display 182 and not 1,048. It's a payroll register. Nothing displays
for detail. I show [FN LN] in the ClientID Footer and Gross Pay
=sum([GrossPay]).

There are 182 Clients that display in the footer. I would like to count who
gets paid for the month--not every single pay day. [FN LN] displays in the
footer. I thought I would just name the field CONSUMER and then try
=count([Consumer]) but that gives me an error. When I used =count([FN LN])
it's totaling all the details.

Thanks!

Count() should work in Report and Group Header and Footer sections, not Page
Headers and Footers.
--
Duane Hookom
Microsoft Access MVP


:

I have a payroll report that displays name, gross pay, and some other
information that displays in the footer (all the detail information doesn't
display). They would like to display the total count of people. I named the
[FN LN] field Consumer in the footer. I tried =Count([Consumer]), but I just
get ERROR. Could someone tell me how to get a count? Thanks!!!