I am trying to find a way to compile a report from two different queries that takes all the payments in and subtracts all the payments out. I need to keep track of the payments into and out of an escrow account and have the total balanced displayed on the main customer form. Any ideas of how this should be accomplished.
Thank you
Thank you