Hi there.
I am struggling so hard with such a simple query - I need qryDueToSteven to calculate what we owe Steven. When you subtract "TotalReceivedFromSteven" ( it is a loan), from "TotalPaidToSteven" (refund for loans), it should calculate what we owe steven, however it is showing the same payment of R100 made to him twice -= but we only paid this amount to him once, therefore making the outstanding due incorrect. i hope i have explained correctly. Please see attached
thank you so much
I am struggling so hard with such a simple query - I need qryDueToSteven to calculate what we owe Steven. When you subtract "TotalReceivedFromSteven" ( it is a loan), from "TotalPaidToSteven" (refund for loans), it should calculate what we owe steven, however it is showing the same payment of R100 made to him twice -= but we only paid this amount to him once, therefore making the outstanding due incorrect. i hope i have explained correctly. Please see attached
thank you so much
