Show number of records at end of report in access.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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])
 
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("*")
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting number of records based on criteria 2
A03 - count in report footer gives me #Error? 0
Day Calculation in Report 6
Counting the number of records in a report 2
Need Help to Count in Footer, then Sum in 2nd Footer then Sum agai 1
Count Value in a report footer 1
Report Group Count Woes 6
2 columns reports set up and report footer 1

Back
Top