By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,525 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

How to include the last data in a report?

P: 55
hi,

i have built a database for a Finance Company with tables such as "tblCustomer" (PK is CustomerID-Autonumber) and "tblLoan"(PK 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 "PrincipleAmountPaid", "PrincipleBalance" 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
Aug 3 '07 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,669
hi,

i have built a database for a Finance Company with tables such as "tblCustomer" (PK is CustomerID-Autonumber) and "tblLoan"(PK 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 "PrincipleAmountPaid", "PrincipleBalance" 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 PrincipleAmountPaid 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.
Aug 7 '07 #2

Expert 100+
P: 296
hi,

i have built a database for a Finance Company with tables such as "tblCustomer" (PK is CustomerID-Autonumber) and "tblLoan"(PK 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 "PrincipleAmountPaid", "PrincipleBalance" 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 PrincipleAmountPaid and PrincipleBalance? If so, try using the Max() function on the date field in your query
Aug 7 '07 #3

P: 55
Do you have a date field for each PrincipleAmountPaid and PrincipleBalance? 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.

PrincipleAmountPaid and PrincipleAmountBalance are in tblLoan

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

i appreciate your help.

thanks a lot
Aug 8 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.