The above is a sample query I have generated from my table. I was to sum up the total Bill_Amt based on the Client_ID and do the same for
Paid_ Amt based the Client_ID. I tried using the dsum function but not giving me what I'm looking for. My Dsum query gave me sum of Bill_Amt
of all clients and not by each client. I need your assistance please.