Access 2007 help

[Fkacn_tt]

I'm try to create a query where, it adds related figures from fields on different rows for a certain individual and outputs the total in totals field.

Eg sale 1 for Tom Black + sale 2 For Tom Black = Total Sale for Tom Black

In the pic below i'm also looking to tweak the query where it onl show the CLID, NO. of sales(using a count of the amount of orders for that specific person), PID, FName, LName, Total.

I really appriciate any help and i know its late.

[Fkacn_tt]

Figured it out, was very simple i'm kind of ashame for asking for help.