How to use the count formula in a report

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

Guest

My access database has a list of all the students in my class, and what I
would like to know is, "How do I make a report that will list the name of all
my students and most importantly give me a count of how many students there
are?"

Thanks!
 
Roberto

The specifics will really depend on how your data is structured.

Generally, create a query that returns all the rows (students' IDs and
names). Use that as the basis of your report.

In the Report or Page Header or Footer, add a control with a source
something like:

=Count([YourIDFieldName])
 
Back
Top