Totals Query Query

[NachoMan]

Friends,
I'm having trouble grasping why I can't get my totals query to work correctly. I have a table called tblEvents. There is a field in this table called [Outcome]. The [Outcome] field will have one of three values: 1. "ESTIMATE FULLY SUCCESSFUL" 2. "ESTIMATE PARTIALLY SUCCESSFUL" and 3. "ESTIMATE FULLY UNSUCCESSFUL."

Currently there are 60 events in the table. I have a report which I want to display (among other things) the number of total events as well as the number of events of each of the three possible outcomes. Also, I want to be able to display (list) each of the events with their [Outcome] values.

1. Can this data be displayed with one query?
2. Is this problem explained clearly?

Any help would be greatly appreciated.

p.s. The actual table is much more complex, but this is just a very simplified example of the type of data that I want to pull. If necessary, I could build a small sample table and query.
Thanks again.

-Lou

 

[Pat Hartman]

1. No. A query can only produce one level of detail. You are asking for three. One detail and two summary levels. Use a query that produces the correct detail records and use the report's sorting and grouping properties to create the summaries.
2. Yes.