Repeating Records in Report Using Subform/Subreport

[Guest]

Records in my report are being repeated according to the number of entries in
my subreport. There are no duplicate records in any of my tables.

I have a Database Report that lists city zoning applications. Each
application can have multiple dates of action by the City Council. City
Council Action Dates are listed in a subreport/subform in the Report detail
section.

Records in the report are repeating according to the number of dates in the
subreport/subform. If there are 3 dates, each application gets listed three
times instead of just once. 2 dates...repeated twice. 1 date = 1 record.

In the example below the record of Zoning Application 1 will be repeated 3
times in my report.

Zoning Application 1

City Council Action & Date
Postponed 5/14/05
Postponed 6/15/05
Approved 7/15/05

Any help or suggestions would be greatly appreciated.

Thanks

 

[Duane Hookom]

Your main report should not have the same level of detail as the subreport.
Don't have the action date details in the main report's record source.