two sql tranform statement on one report

[Alan]

How do i get two tranforms statement on the same report but the pivot part
to only be used like below

Tranform
Select
From
Where
Group By
Pivot in (1,3,5,7)

then another on same report

Tranform
Select
From
Where
Group By
Pivot in (2,4,6,8)

any ideas???

 

[John Spencer]

One way I can think of is to use sub-reports.

The other option would be to use a union query to combine the two crosstab
queries if the queries were returning the same basic data. And then group by
the "source"

SELECT "A" as Source, FldA, FldB
, [1] as A, [3] as B, [5] as C, [7] as D
FROM QueryA
UNION ALL
SELECT "B" as Source, Fldx, Fldy
, [2] as A, [4] as B, [6] as C, [8] as D
FROM QueryB

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County