Need Assistance -Query

[Fandy]

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.

 

[cheekybuddha]

You haven't really given us much detail to work with, but you might start with a base query like:

SELECT
  Client_ID,
  SUM(Bill_Amt) AS Total_Billed,
  SUM(Paid_Amt) AS Total_Paid
FROM Transaction
GROUP BY Client_ID
;

 

[Ranman256]

your example shows you are summing for EVERY field in the table.
Sum for ONLY the fields you want, like CheekyBuddha shows.
or
sum per person per date

 

[Fandy]

You haven't really given us much detail to work with, but you might start with a base query like:

SELECT
  Client_ID,
  SUM(Bill_Amt) AS Total_Billed,
  SUM(Paid_Amt) AS Total_Paid
FROM Transaction
GROUP BY Client_ID
;

Pls hw do I get the balance from your above query. Can you me pls

 

[cheekybuddha]

Try:

SELECT
  Client_ID,
  SUM(Bill_Amt) AS Total_Billed,
  SUM(Paid_Amt) AS Total_Paid,
  SUM(Bill_Amt) - SUM(Paid_Amt) AS Balance
FROM Transaction
GROUP BY Client_ID
;

 

[Fandy]

Try:

SELECT
  Client_ID,
  SUM(Bill_Amt) AS Total_Billed,
  SUM(Paid_Amt) AS Total_Paid,
  SUM(Bill_Amt) - SUM(Paid_Amt) AS Balance
FROM Transaction
GROUP BY Client_ID
;

Thank you.