question

FlinnRandalJ-5432 avatar image
0 Votes"
FlinnRandalJ-5432 asked gustav commented

Additional Calculations in Crosstab Query

I have the following Crosstab query.

TRANSFORM Sum(qryBldg6Hrs.[Total quantity]) AS [SumOfTotal quantity]
SELECT qryBldg6Hrs.[Cost element name], qryBldg6Hrs.[Fiscal Year], Sum(qryBldg6Hrs.[Total quantity]) AS [Total Of Total quantity]
FROM qryBldg6Hrs
GROUP BY qryBldg6Hrs.[Cost element name], qryBldg6Hrs.[Fiscal Year]
PIVOT qryBldg6Hrs.[Order Type];

Where A, B, C, D, E and F are [Order Types], I would like to add two columns (Reactive & Not Reactive) that calculate subtotals based on the following...

For each FY value:
Reactive = Order Types A+B+F
Not Reactive = Order Types C+D+E

How do I add that request in the Crosstab query?

198748-image.png

office-access-dev
image.png (6.5 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Create a new normal select query using the crosstab query as source.
Then add the two calculated fields:

 [Reactive]: [A]+[B]+[F]
 [Not Reactive]: [C]+[D]+[E]
0 Votes 0 ·

0 Answers