Search results

  1. B

    How to exclude blank field from SUM calculated field

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

    Query Criteria fomula

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