Column names

L

Lucson

1- I am able to transpose only one serialnumber, but BOMPart# doesn't
display as column header. Instead, it displays the part number as column in
both header and field.
2-when I run the prime query and pull back many SerialNumbers, I cannot
transpose.

Your help is appreciated.
SerialNumber Quantity DATE PRICE BOMPart#
SS4422 12 01/12/07 A AC2-456
SS4422 12 01/12/07 A BH1-313
SS4422 12 01/12/07 A HHT-190
SS4422 12 01/12/07 A CHR-123
SS4422 12 01/12/07 A OLF-890
SR2233 6 05/14/07 B QPR-233
SR2233 6 05/14/07 B SCC-231
SR2233 6 05/14/07 B LOP-245
SR2233 6 05/14/07 B TOL-357
SR2233 6 05/14/07 B SLP-951
AND321 8 06/09/07 C WER-258
AND321 8 06/09/07 C DGO-569
AND321 8 06/09/07 C CFR-248
AND321 8 06/09/07 C HFS-256
AND321 8 06/09/07 C XSP-268
AND321 8 06/09/07 C BPY-456

Here is what I need
SerialNumber Quantity DATE PRICE BOMPart# BOMPart# BOMPart# BOMPart# BOMPart# BOMPart# BOMPart# BOMPart#
SS4422 12 01/12/07 A AC2-456 BH1-313 HHT-190 CHR-123 OLF-890
SR2233 6 05/14/07 B QPR-233 SCC-231 LOP-245 TOL-357 SLP-951
AND321 8 06/09/07 C WER-258 DGO-569 CFR-248 HFS-256 XSP-268 BPY-456
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 - Transpose 7
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Find then highlight in yellow 6
Get the last price 3
Looping through data with calculations 1
Reverse Index Match 2
Advanced problem using auto-number and datediff to find readmissio 2
Crosstab Query based on Ordinal Values 6

Top