Report Sum with Multiple Relationships

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.

--
Build a little, test a little.


"pstrigen" wrote:

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)?

I worked around the issue. I just created a sub-report to minimize the
duplication issue.

Thanks,
Peter

"KARL DEWEY" wrote:

What about posting sample data for what you put in words?
Post the SQL of the query.

--
Build a little, test a little.


"pstrigen" wrote:

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)?