How to obtain a table summary using QUERY function?

[Crystallew]

Hi..(",o) anyone can HELP?

I'm currently using MS Access 2000...
May i know how can I translate the following TABLE

Doc# Team# Status
D1 TA Done
D1 TB WIP
D1 TC WIP
D1 TD Done
D2 TA Done
D2 TB Done
D2 TC Done
D2 TD WIP

to a QUERY reflecting in the following format?

TA TB TC TD
D1 Done WIP WIP Done
D2 Done Done Done WIP


Your help will be greatly appreciated!

 

[Jon K]

Try this Crosstab Query, replacing with the correct table name:-

TRANSFORM First([TableName].[Status]) AS [Status]
SELECT [Doc#]
FROM [TableName]
GROUP BY [Doc#]
PIVOT [Team#];

Note: It's better not to use special characters in field names.
.

 

[Crystallew]

Hi Jon K (",o)

Thanks so much!!!! ... I Got iT .... Thanks Thanks .... Cheers!