Report previews multiple times

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

Guest

I work with a database that allows users to enter multiple discrepancies into
a table under one unique report number. The table and queary both show the
report number once for each entered discrepancy. I have a report that shows
the discrepancy information in a sub-report, but the entire report repeats
itself for each entered discrepancy. How can I get each report to preview
only once if it has multiple discrepancies? Thanks for any help
 
I expect you have too much detail in your main report. It seems that the
main report should not contain the discrepancy information.
 
The main report does have a lot of information, but the discrepancy
information is on fairly small attached sub-report. The sub-reports are
grouped by report number with the main report, and the report number field is
the only one the reports have in common.
Dan
 
Yes, it has two quearies that have the discrepancy information, joined to the
main table by report number
 
You first stated "but the discrepancy information is on fairly small
attached sub-report" and then stated the discrepancy records are alos in the
main report. My suggestion has been to remove the discrepancy table from the
record source of the main report.
 
I removed the discrepancy table and found the problem was with my main report
queary the whole time. It is based on quearies itself, and causing the
repeat reports. I'm trying to rebuild the main report queary from tables to
prevent that.
 
Back
Top