Report Sum with Multiple Relationships

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

KARL DEWEY

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

pstrigen

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

Thanks,
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top