Report from a Query

[MarieD]

I have a query that is pulling 463 records of dates and then the data is either a 1 or 0. 1 = Yes, 0 = No.

SELECT [Pacer QA tbl].Pneumothorax, [Pacer QA tbl].PericardialEffusionTamponade, [Pacer QA tbl].HematomaRequIntervention, [Pacer QA tbl].Other, [Pacer QA tbl].[LeadRevision>TwelveMonths], [Pacer QA tbl].[LeadRevision<Twelve Months], [Pacer QA tbl].[PocketRevision<Twelve Months], [Pacer QA tbl].[DeviceUpgrade<TwelveMonths], [Pacer QA tbl].[Infection<SixMonths], [Pacer QA tbl].[GeneratorChange<FiveYrs]
FROM [Pacer QA tbl];

In the report I am totalling all of the 1 values under each complications and then adding complications percent against the total of procedures. The report should only be 1 page, but it is 156 pages, repeating the first page over and over. Can you tell me what I need to look for to resolve this? This report will need to be embedded into another report. I have made sure that there is no extra white space in the report, checked the properties on all of the fields. (I've attached the report. I had to deleted all but 2 pages to export it.)

 

[SOS]

Did you put your fields in the GROUP or in the DETAIL section. I think you need them in the GROUP.

 

[MarieD]

The fields are in the detail section. Do you mean to make a separate group for each of the 9 fields using the Sorting and Grouping.

 

[MarieD]

I tried each field in a group header. The attached is the way it looks now. It is still repeating the information. How do I stop this?

 

[DCrake]

Create a new query based on this query that does the agregate totals and base your report on this new query.

 

[MarieD]

Ok, I've got that part figured out. I had to take the field 'date of procedure' out of the aggregate query. I now have one page in the report showing all of the complication fields and the count of complications for each type.

But now I need to get a percentage of complications by dividing the number of pneumothorax complications by the total of device cases. Without the 'date of procedure' field in the query, how do I accomplish this?