Duplication of Value

  • Thread starter Thread starter Patrick Graham
  • Start date Start date
P

Patrick Graham

Hello,

This seems like it should be easy but its killing me.

I have one table called tblAdvisor with IPS, AdvisorID.
I have one table called tblIPS with a value IPS, x and y.
I have another table called tblAccount with IPS,
AccountNumber, AccountBalance.

A single Advisor can have many IPSs.
A single IPS can have many accounts.

I'm trying to create a report that sums the
AccountBalance and the x and y for the Advisors.

Problem is that the query I have now gives results like
this.

AdvisorID / IPS / x / y / AccountNumber / AccountBalance
1 / 100 / $10 / $20 / 4AA0W / $100
1 / 100 / $10 / $20 / 4AB0W / $200
1 / 101 / $30 / $25 / 4AC0W / $300

And when I sum in the report I get x and y doubling up
because the account number is shown twice.

How do I prevent the doubling up?
 
Back
Top