Avatar of Sabealgo
Sabealgo asked on

Access 2007 Report

Hello,
This inquiry is related to a travel business and the costs that are being reported.  In one report we capture the total insurance field.  On a second report, the cost summary report, we capture the total cost of a trip - including airfare, hotels,etc. This total cost doesn't itemize the details, but just provides a total minus any payments made by the customer.  However this summary report doesn't include the total insurance.  So when a customer has made a payment toward the trip, the difference showing is the insurance paid.

For example -
Total cost   = 1,000
Total payments = 1,200

Balance due =(200)

In this example the customer's total payments also included the insurance.

My question is how can I capture the cost of the insurance as part of the Total cost so that this report balances out correctly?  I would classify myself as a basic user and struggle with reports.  But it seems to me that I have to find where the total cost is captured and find out what it's components are so that I can add the insurance component.    My question is two fold -

1.  Normally where could I look to find the Total Cost (again including various fees, and expenses)?  

2.  Once I find where the Total Cost is, how could I add the insurance amount to it?
Microsoft Access

Avatar of undefined
Last Comment
Sabealgo

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
mbizup

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Graham Mandeno

Awesome answer, Miriam ... I was at a loss where to start with so little information :-)
mbizup

Thanks, Graham :)
Richard Daneke

Certainly, not knowing the details of your database makes targeted help difficult.  

I think the key in solving the problem is a better understanding of reports.  First, make a copy of your database before you start looking in the design.  AND, look in the copy you made to protect you from making accidental changes!

Reports are based on queries.  The two reports you mention both have a query that provides the records with the costs.   When you look at the report in design view, you can open the property sheet.  In the top, use the combo box to chose the Report as seen in the picture below.  Open Report Properties
Click on the data tab, then click on the button with the ... to the right of the record source.

This opens the underlying query used in the report.   It sounds like the query used to total costs against payments is not including insurance or is excluding the insurance costs.  Compare this query against the one used to provide insurance costs.  It may better illuminate your solution.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER
Sabealgo

Thank you for the feedback.  I tried to get additional information regarding the structure of the database, but ran in to a wall.  This solution helped.
Sorry for the delay in resolving.