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 total of 700.00
I have attached screenshot of my query.
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 total of 700.00
I have attached screenshot of my query.