Counting entries of a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daiv - 25 Feb 2007 23:30 GMT

I have a database that generates multiple reports about a companies
transactions based on where the funding is from, and the programs it is
dispersed into. When generating these reports I would like to count the
transactions listed under each category, and again at the end with a total #.
what function could I use for this? I tried the count function in a query
but it didn't give me options for "group by" or "count" and complained when i
typed them in.

Thanks!

Reply to this Message

Tom Wickerath - 25 Feb 2007 23:45 GMT

Hi Daiv,

You can do the counting directly within the report. An example is shown for
you in the sample Northwind database (Northwind.mdb), which ships with every
copy of Access. Open the Products by Category report. You should see the
following label caption and calculated control in the CategoryName Footer
section:

Number of Products: =Count([ProductName])

To get a grand total, you can copy this label and text box and paste it into
the report's Report Footer section (not the Page Footer). For example:

Total Number of Products: =Count([ProductName])

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

> I have a database that generates multiple reports about a companies
> transactions based on where the funding is from, and the programs it is
[quoted text clipped - 5 lines]
>
> Thanks!

Reply to this Message