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?