On the report I have the following fields that are added together but do not add up correctly
$0 $1,959 $1,113,017 $2,307,445 $21,250 $284,820
equals on the report as $3,726,536 but on a calculator and excel equal $3,728,491
Jim Wagner
________________________________
________________________________
From: luvmymelody <luvmymelody@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, July 12, 2013 8:59 AM
Subject: [MS_AccessPros] Calculation in report is incorrect.
Hello all,
I have a report based on a crosstab query and the data is correct that I see. But on the report several things have confused me.
The fields in the report footer that calculate the columns are correct based on the query and putting the query in excel. They match exactly.
The calculations for the rows are the ones are not calculating correctly. Subsequently the totals for the calculated column is off by 29K. I have formatted all controls to be Currency and 0 decimal points. How do I get the row calculation to be calculated correctly?
Thank You
Jim Wagner
The sql is below
TRANSFORM Sum([Safety]+[DamageWear]+[CodesStandards]+[EnvironmentImprovement]+[EnergyConservation]+[Asbestos]) AS rpttype
SELECT [Building Inspection Data].ReportType, [VALUE LIST - Report Types].ReportTypeDescription, [VALUE LIST - Report Types].Order, [Building Inspection Data].Residential
FROM [Building Inspection Data] INNER JOIN [VALUE LIST - Report Types] ON [Building Inspection Data].ReportType = [VALUE LIST - Report Types].ReportType
GROUP BY [Building Inspection Data].ReportType, [VALUE LIST - Report Types].ReportTypeDescription, [VALUE LIST - Report Types].Order, [Building Inspection Data].Residential
PIVOT [Building Inspection Data].Campus;
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar