Hi,
I am planning to make the Query with the following fields (in illustration below).
I would like to sum the total Purchase Amount (F3) who has Paid (F4) per Customer Name (F2).
For example:
Bob T has paid $200.00 (Purchase Number 2 in F1) and $100.00 (Purchase Number 9 in F1). Query...