Monthly Total

[gullfounder]

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?

 

 

08-Apr-2014.zip

[Matthew F]

Change the layout setup to show records from 'Payments_Line' table rather than the 'Payments' table. 

[gullfounder]

Change the layout setup to show records from 'Payments_Line' table rather than the 'Payments' table. 

Thanks it worked.