intermittent extra line items appear

  • Thread starter Thread starter heg
  • Start date Start date
H

heg

My report draws its detail section from a sub-form. Each
line item has two text box fields containing running sums
that are used for calculated fields in the page footer.
Sometimes-not always-the line items are repeated from 2 to
6 times on the report. When that happens the calculated
fields in the footer section shows figures that are
inflated by the same factor. If there is one line of data
in the subform how can I be getting multiples of that line
on my reports. I can find no correlation between records
that print correctly or records that print incorrectly.
The tables that result from the same sub-form are
correct--no extra line items or inflated values.
 
Your report is based on a query?
If so, open the query directly, and see if the extra lines appear there.

My guess is that you have a query that includes a related table, so where
your subform table has multiple entries in the related table, it results in
multiple entries in the final report.
 
Back
Top