Calculate Balance based on Date

Hi all,   So I have 3 tables, one with customers, one with customers' charges and one with customers' payments. I am trying to figure out a good way to get a balance for each customer. The user wan...