How to include the last data in a report?

[ontherun]

hi,

i have built a database for a Finance Company with tables such as "tblCustome r" (PK is CustomerID-Autonumber) and "tblLoan"(P K is LoanNumber).
the table tblLoan has information for each month comprises of interestPaid, InterestBalance , TotalArrears etc.

I have a report called "OrderStatement " based on parameter query to create a statement for a customer.
the query is such that, based on the LoanNumber entered by the user, it shows all the information for the customer right from the beginning of the loan sanctioned till the current date.
i dont have problem in getting the desired statement but along with the query result, i need to get the last entered values for "PrincipleAmoun tPaid", "PrincipleBalan ce" into my report.
As of now, it is showing for each month but what i want is to get the last entered value for these two fields.

Could anyone help me in this regard?

thanks

[ADezii]

hi,

i have built a database for a Finance Company with tables such as "tblCustome r" (PK is CustomerID-Autonumber) and "tblLoan"(P K is LoanNumber).
the table tblLoan has information for each month comprises of interestPaid, InterestBalance , TotalArrears etc.

I have a report called "OrderStatement " based on parameter query to create a statement for a customer.
the query is such that, based on the LoanNumber entered by the user, it shows all the information for the customer right from the beginning of the loan sanctioned till the current date.
i dont have problem in getting the desired statement but along with the query result, i need to get the last entered values for "PrincipleAmoun tPaid", "PrincipleBalan ce" into my report.
As of now, it is showing for each month but what i want is to get the last entered value for these two fields.

Could anyone help me in this regard?

thanks

We will need much more information than this in order to assist you.

1. Is there a Linking Field between tblCustomer and tblLoan. There should be a 1 to MANY relationship since a Customer can have more than 1 loan. What is the Name and Data Type of this Field?
2. Where do the Fields PrincipleAmount Paid and Principle Balance exist (what Table). Is this Table related to other Tables and by which Fields.
3. Are the above mentioned Fields Running Balances, something similar to an Amortization Table?
4. Is the Table comprising these Fields a Child Table? What is the Parent Table?
5. We will definately need clarification on this and other facts.

[mlcampeau]

hi,

i have built a database for a Finance Company with tables such as "tblCustome r" (PK is CustomerID-Autonumber) and "tblLoan"(P K is LoanNumber).
the table tblLoan has information for each month comprises of interestPaid, InterestBalance , TotalArrears etc.

I have a report called "OrderStatement " based on parameter query to create a statement for a customer.
the query is such that, based on the LoanNumber entered by the user, it shows all the information for the customer right from the beginning of the loan sanctioned till the current date.
i dont have problem in getting the desired statement but along with the query result, i need to get the last entered values for "PrincipleAmoun tPaid", "PrincipleBalan ce" into my report.
As of now, it is showing for each month but what i want is to get the last entered value for these two fields.

Could anyone help me in this regard?

thanks

Do you have a date field for each PrincipleAmount Paid and PrincipleBalanc e? If so, try using the Max() function on the date field in your query

[ontherun]

Do you have a date field for each PrincipleAmount Paid and PrincipleBalanc e? If so, try using the Max() function on the date field in your query

thanks for your reply guys...
i have only 2 tables... tblCustomer and tblLoan with 1 to Many relationship

Loan Number (Autonumber and PK for tblCustomer) connects this two tables.

PrincipleAmount Paid and PrincipleAmount Balance are in tblLoan

i havnt used the Max() function in the query yet... will try this time...

i appreciate your help.

thanks a lot