Converting some fields to columns

[aine_canby]

Hi,

I have the following table -

Test Tester Result
Test1 Brian Pass
Test1 John Pass
Test21 Brian Fail
Test23 John Pass
Test77 John Fail
Test111 Aine Pass
Test111 John Pass

what query would i need to achieve the following -

Test Aine Brian John
Test1 Null Pass Pass
Test21 Null Fail Null
Test23 Null Null Pass
Test77 Null Null Fail
Test111 Pass Null Pass

Thanks,

Aine

 

[Gary Walter]

<aine_ wrote:...

Hi,

I have the following table -

Test Tester Result
Test1 Brian Pass
Test1 John Pass
Test21 Brian Fail
Test23 John Pass
Test77 John Fail
Test111 Aine Pass
Test111 John Pass

what query would i need to achieve the following -

Test Aine Brian John
Test1 Null Pass Pass
Test21 Null Fail Null
Test23 Null Null Pass
Test77 Null Null Fail
Test111 Pass Null Pass

Hi Aine,

Looks like a good candidate for a crosstab query...

If name of your table was "tblTest" then try...

TRANSFORM FIRST(NZ([Result]),"Null"))
SELECT
Test
FROM
tblTest
GROUP BY
Test
PIVOT Tester;

good luck,

gary