Show number of records at end of report in access.

J

Joanne627

I want to show the total number of records at the bottom of a report in Access.
I think it the formula =Count({FirstName)} should work, but I can't figure
out how to insert this onto the footer.
 
W

Wayne-I-M

Hi

Create an unbound text box and place it in the report footer.

Use this as the control source for the text box.

=Count([firstname])
 
F

fredg

I want to show the total number of records at the bottom of a report in Access.
I think it the formula =Count({FirstName)} should work, but I can't figure
out how to insert this onto the footer.
Click to expand...

use an unbound text control in the REPORT Footer (not the Page
Footer).
=Count("*")
 
J

Joanne627

Thanks so much! "unbound text box" was exactly the clue I needed.

Wayne-I-M said:
Hi

Create an unbound text box and place it in the report footer.

Use this as the control source for the text box.

=Count([firstname])


--
Wayne
Manchester, England.



Joanne627 said:
I want to show the total number of records at the bottom of a report in Access.
I think it the formula =Count({FirstName)} should work, but I can't figure
out how to insert this onto the footer.
Click to expand...
Click to expand...
 
Top