473,320 Members | 2,158 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to include the last data in a report?

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
3 1078
ADezii
8,834 Expert 8TB
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
mlcampeau
296 Expert 100+
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
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

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

Similar topics

1
by: bjam | last post by:
Hi, today I was able to abstract out into a separate xsl file a template that I specifically perform a call templates for, this worked with import no problem. However, when trying to do the same...
4
by: deko | last post by:
I can't move a multi-page report to the last record unless I keep the popup form (that defined it's subreports) open. DoCmd.OpenReport "rptStandard", acViewNormal DoCmd.Close acForm,...
1
by: Phillip Lyles | last post by:
Hi Everybody, First of all if this has been asked 1000 times I am sorry. Is there a way in Access 2002 to open a report and have it go to the last page of the report and print just the last page? ...
17
by: michel.ank | last post by:
Hi, I'm using the class PrintLines and my last record of page aren't with the borders. Somebody can help me? Thanks,
13
by: Greg | last post by:
Most suggestions on this topic recommend to use a page footer and make it visible only on the last page. My problem is that the footer is half of the height of a page which means the detail would...
1
by: madhuxml82 | last post by:
Dear Forum Members I am giving an XML Format. <?xml version="1.0" encoding="ISO-8859-1" ?> <XML-SSDFILELIST> <Training> <a1.LABELNAME><!]></a1.LABELNAME> <a1.KEY><!]></a1.KEY> ...
17
by: Francine.Neary | last post by:
I have a program that uses a large lookup table, provided as a large array in the source: static int bigtbl={123, 456, /* etc. etc. */ 9999 }; Now this table is pretty big, and having it...
1
by: daverskully | last post by:
Table: Data Form: Entry Form Fields: 1) Department 2) DepartmentNumber 3) AccountExecutive 4) ReportDate 5) ID 6) 7 yes/no fields
21
by: kurai hikari | last post by:
i have a combobox from table( specialization) and i have a reports from table (managers) the combobox name is( combo1) the selections in the combo box are managersjob governorsjob...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.