We help IT Professionals succeed at work.
Get Started

Access 2007 Report

Sabealgo
Sabealgo asked
on
338 Views
Last Modified: 2014-06-11
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?
Comment
Watch Question
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE