AnsweredAssumed Answered

Monthly Total

Question asked by gullfounder on Apr 8, 2014

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

Outcomes