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 result will show Bob T with Sum of Paid Amount of $300.00 (it excludes the unpaid transaction of Purchase Number 5 & 6).
Thanks in Advance.
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 result will show Bob T with Sum of Paid Amount of $300.00 (it excludes the unpaid transaction of Purchase Number 5 & 6).
Thanks in Advance.
Purchase Number (F1) | Customer Name (F2) | Purchase Amount (F3) | Paid? (if not paid leave empty) (F4) |
---|---|---|---|
1 | Rex D | $100.00 | |
2 | Bob T | $200.00 | Paid |
3 | May X | $300.00 | |
4 | Abram C | $400.00 | Paid |
5 | Bob T | $100.00 | |
6 | Bob T | $230.00 | |
7 | Abram C | $300.00 | |
9 | Bob T | $100.00 | Paid |