Report Sum with Multiple Relationships

  • Thread starter Thread starter pstrigen
  • Start date Start date
P

pstrigen

I am trying to sum a field in a query on a report but the object table(1) in
the query has a many-to-one relationship with another object table(2). I am
trying to sum a value in the object table(1) but the query shows a line for
each multiple relationship from object table(2) thus duplicating those
values. How do you only include one value from each record from object
table(1) and report all records from object table(2)?
 
What about posting sample data for what you put in words?
Post the SQL of the query.
 
I worked around the issue. I just created a sub-report to minimize the
duplication issue.

Thanks,
Peter
 
Back
Top