AnsweredAssumed Answered

Monthly Total

Question asked by gullfounder on Apr 8, 2014


Monthly Total



     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.