Search results

Hi Silentwolf, It did filter out the blank VoucherNumber field (attached photo), however I'd also like to SUM the PurchaseInvoiceAmount group by VendorName.

Hi, Hope someone can help. I would like to sum up the records that has VoucherNumber group by VendorName. Ignore or excludes the ones without VoucherName. In this case, the query should only show this result with VoucherNumber Bob T with total of 1100.00, Kay C with total of 400.00 Rex M with...

I'll post screenshot of what I meant. I would like to sum up the records that has VoucherNumber group by VendorName. Ignore or excludes the ones without VoucherName. In this case, the query should only show this result with VoucherNumber Bob T with total of 1100.00, Kay C with total of...

The criteria is the voucher should have data.

Thanks Gasman, Do I put that in the CustomerName criteria?

Here's the real table: So i wanted the query to Sum CustomerName and Purchase Amount that has VoucherNumber. Example: Bob T $300 Abram C. $800 Purchase Number (F1) Customer Name (F2) Purchase Amount (F3) Voucher Number (F4) 1 Rex D $100.00 2 Bob T $200.00 V111 3 May X $300.00 4...

Hi LanaR, Thanks for such a prompt reply. Appreciate it. Yes, the above is for illustrative purpose. The Paid field is actually VoucherNumber. So what I am looking for is IF there is VoucherNumber, I would like to SUM only the amount with VoucherNumber. Yes, I have normalised table...

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...