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;
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar