How do I set up a report to get # of participants by agency in Acc

P

PVKowgirl

I am new to Access and have created a conference database. I need to report
on the number of participants who attended by their agency. How do I set up
a report to reflect this information?
 
D

David Lloyd

Hopefully, the following references can get you started. First, you should
create a query to calculate the number of participants by agency. This
normally done with a "GROUP BY" query, using the "Count" aggregate function.
The following KB article give more information on creating such a query. In
the article, the instructions refer to the SUM function. Just use the Count
function instead.

http://support.microsoft.com/default.aspx?scid=kb;en-us;304361

Your query might look similar to the following:

SELECT Agency, Count(*) as AgencyCount
FROM MyTable
GROUP BY Agency

Once you have created the query, you can use it as the basis for your report
(Record Source property). Below is a download link for some sample Access
reports that you can use as a guide.

http://www.microsoft.com/downloads/...A5-C76F-4EDA-BC9A-5FAC336EF7F1&displaylang=en

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am new to Access and have created a conference database. I need to report
on the number of participants who attended by their agency. How do I set up
a report to reflect this information?
 

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