0 Replies Latest reply on Apr 8, 2014 11:49 AM by gullfounder

    Monthly Total

    gullfounder

      Title

      Monthly Total

      Post

           Hi,

           I have small issue. I have created to 2 tables. Payments and PaymentLine. Payment is parent and PaymentLine is child. Payment has 2 fields. ID and Date where as PaymentLine has fields amount category note and check no.

           I want to create a list of all Payments Records they occurred in one month and total amount. I created a Summary Field in PaymentLine table and made it total of Amounts. But i perform search using a Perform Find. I don't get the total of the month. Instead i get total of all the records. What i am missing?

           Sharing a Link to a file on which i have worked so far.

           https://www.dropbox.com/s/8icvc99r6dgkiod/08-Apr-2014.fmp12