Summary Count for Specific Text Box Data in a Report

[floydpepper]

Ladies and Gents,
I have a report that lists:
Event, Outcome 1, Outcome 2

I have several different events that I log, such as "accept" and "return". Is there a way to have the total count of each event type (eg return = 7 total, accept = 8 total) in the footer of this report? I appreciate your help.

FloydP

 

[formerTexan]

Floyd Pepper

THere are a few ways, but unless you have some additional requirements, perhaps the easiest way will be to add a subreport. Add a list box and set its rowsource to a query similiar to what follows.

SELECT YourTable.Event(YourTable.ID) AS CountOfID
FROM YourTable
GROUP BY YourTable.Event;

Cheers
Bill

 

[SuicidED]

Another way have the control source of your text box
=Sum(IIf([outcome1]="Return",1,0)) and so on