How to use the count formula in a report

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!
 
J

Jeff Boyce

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])
 

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

Top