Subform Troubles

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

Guest

I have a report based on a form with a subform.

The basic idea is that the subform will look up the contractor address from
the contractor table, and I have a query that does that.

This appears to be working fine on the form, but when I build the report,
I'm getting multiple copies of the address in some cases.

I guess that something is wrong with the underlying query, and that somehow
if there are five contracts in the database with this contractor I'm getting
five copies of the address

Any thoughts? I'm not sure which code is appropriate to post. Thanks.
 
Hi there!

Have you tried using Grouping in your query to eliminate
the multiple records. Make sure that the result set that
your query is producing does not show extra field that
would make each instance of the contractor a unique
record. If you use grouping it will fix this problem.

Hope this addresses your problem.
 
Back
Top