Repeating Records in Report Using Subform/Subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top