Crosstab Query - Column headings

[Guest]

I'm trying to duplicate an Excel spreadsheet using a crosstab query in Access
2002. The data consists of Material Descriptions each having an ID. The user
wants to see both of these on 2 different rows. The value is the same for
both.
Example: Material Description = DMT
Material ID = 1008

Material: DMT
1008
Value: .67
How do I get 2 column headings?

Thanks!

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You will have to concatenate the 2 values together using the Pivot
clause:
TRANSFORM ...
etc.
PIVOT [Material Description] & " " & [Material ID]

Don't include the column [Material ID] in the SELECT clause. The
Material Description & Material ID will be sorted left to right.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQX/eh4echKqOuFEgEQKziQCfbRlqGFWTac/Ih3leK40PFbDuRZ4An26u
IbGx+vMRP4Cy1atuoEd1twHs
=G8Wf
-----END PGP SIGNATURE-----