I am pretty new to access, but I am working on an oil and gas royalty distribution database. The quick background is that royalty revenue is recieved from production on a well. Royalty payments are then owed to the royalty owners. I have the recieving payments and the royalty owners established and expressions built to show their respective payments they are owed. I need some help on what it takes to record the payments to the royalty owners and also a way to look up unpaid balances. If you have any suggestions or avenues to look down that would be greatly appreciated.