jenniejadin
Technical User
- Apr 3, 2008
- 1
When working with the data pulled for the SumOfAmount, which is the Amount from the Table TblServiceVisits, my relationship is off somehow.
TblVisitCharges ID 1035 has a charge of $102.00,
TblInvoiceParts InvoiceID 339 has a charge "Freight Charges" for $5.20, a charge "Door Handles" for $5.52, a charge "Timer Knob" for $2.89, and a Charge for "Choke Cover" for $.62
Each data line returns Auth#, where there can be some, one or none VisitInvoice ID's and there can be some, one or none PartsInvoice ID's. Each VisitInvoice and Each PartsInvoice is independent of each other but must be tied and totaled in relationship to the Auth#.
In my example with ID#1035 and one of each of the part charges on InvoiceID#339 after pulling the data into excel, I created a pivot table on the TblVisitCharges ID's and receive a total back of $408.00, which is 4 X's the rate, because it is pulling the VisitInvoice total each there is a PartsInvoice ChargeID.
Do you see this problem? What can I do to keep the total from multiplying?
I also have a problem with the InvoiceID charge amounts....when I do anything with $ values, the digits are correct but they are all moved to the left a decimal point. What should appear as $39.74, shows up as $397.40
Can anyone guess what might be the problem?
TblVisitCharges ID 1035 has a charge of $102.00,
TblInvoiceParts InvoiceID 339 has a charge "Freight Charges" for $5.20, a charge "Door Handles" for $5.52, a charge "Timer Knob" for $2.89, and a Charge for "Choke Cover" for $.62
Each data line returns Auth#, where there can be some, one or none VisitInvoice ID's and there can be some, one or none PartsInvoice ID's. Each VisitInvoice and Each PartsInvoice is independent of each other but must be tied and totaled in relationship to the Auth#.
In my example with ID#1035 and one of each of the part charges on InvoiceID#339 after pulling the data into excel, I created a pivot table on the TblVisitCharges ID's and receive a total back of $408.00, which is 4 X's the rate, because it is pulling the VisitInvoice total each there is a PartsInvoice ChargeID.
Do you see this problem? What can I do to keep the total from multiplying?
I also have a problem with the InvoiceID charge amounts....when I do anything with $ values, the digits are correct but they are all moved to the left a decimal point. What should appear as $39.74, shows up as $397.40
Can anyone guess what might be the problem?
