Results 1 to 2 of 2

Thread: Record Summary

  1. #1
    Join Date
    May 2005

    Unanswered: Record Summary

    I have 2 tables: Invoice & Cash Receipt

    For each invoice, I may have multiple cash receipts applied to it.
    How do I sum up all the cash receipts and subtract it from the invoice?


  2. #2
    Join Date
    Dec 2004
    Assuming your tables are related (the cash receipts table includes the invoice number), group the records by invoice number and in the group footer (summary section), put in a formula that looks like INVOICE.Total - Sum(CASH_RECEIPTS.Amount)

    Highlight the amount and click the summary button to add the summary to the group footer. The invoice total should be the same for all records, so just add that field to the group footer. This will help you get the syntax for the formula right.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts