How do I stop from getting repeats

[Guest]

I have a table with customer invoice information on it. I have another table
with customer payment information on it. With a query I want to make an AR
balance sheet to show what is outstanding for a spacific client. When I try
to do a query with each table linked on the customer name I get repeated
invoice results that seem to match the numnber of payments made to the
account. the possibility of more than one payment being made to an oustanding
invoice is high so that is why I am getting these results. Is there a way to
have unequal results? (Which is what I want) If I have one invoice for lets
say $100 and two payments of $40 each I still have and outstanding ballance.
The querry showes the invoice repeated for each payment made. Or is there a
better way to do this so I can have a balace sheet?

 

[John Vinson]

I have a table with customer invoice information on it. I have another table
with customer payment information on it. With a query I want to make an AR
balance sheet to show what is outstanding for a spacific client. When I try
to do a query with each table linked on the customer name I get repeated
invoice results that seem to match the numnber of payments made to the
account. the possibility of more than one payment being made to an oustanding
invoice is high so that is why I am getting these results. Is there a way to
have unequal results? (Which is what I want) If I have one invoice for lets
say $100 and two payments of $40 each I still have and outstanding ballance.
The querry showes the invoice repeated for each payment made. Or is there a
better way to do this so I can have a balace sheet?

You'll need a Totals query summing payments and summing costs. Without
knowing the structure of your tables it's hard to suggest exactly how
this would be structured (for instance, if you re-invoice unpaid
charges, then you'll need to somehow prevent summing the repeated
dunning letters).

John W. Vinson[MVP]