How do I get detail from one table with sum from another table in one query

I have two tables, a client table and a transactions table. All the different records on the transactions table have Amounts adding up to a balance total for the client table. I want to show the client table detail plus the sum of the transactions amounts (as the client balance). The ClientId is a foreign key on the transactions table.
My query needs to show a selected client’s detail with the total.

I saw a solution for mySQL but cannot find one for ms access?

Please, I’m searching and searching and wasting time ….
Thank you.