Prev: form still on task bar
Next: Windows Media Center - pictures are auto archiving?/disappearing
From: Alan on 12 Apr 2010 07:35
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???


From: John Spencer on 12 Apr 2010 09:05
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

Alan wrote:
> 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???
>
>
 | 
Pages: 1
Prev: form still on task bar
Next: Windows Media Center - pictures are auto archiving?/disappearing