How do I do this?

[PointerMan]

I have an Access database with 3 columns of data that have about 220,000 rows
of information in each. I want to take the vertical data and make it into a
more horizontal chart. Here's my example:

Number Job Sequence
A 10 10
A 5 20
A 20 30
A 5 40
B 10 10
B 5 20
B 70 30
B 5 40
B 25A 50
C 10 10
C 5 20
C 70 30
C 5 40
C 25A 50
C 5 60


10 20 30 40 50 60 70
A
B
C
D

Does anyone know how to do this? I don't know much about Access, so
unfortunately I'm asking for a simplistic answer!

 

[Duane Hookom]

Have you tried creating a crosstab query with Number as the Row Heading,
Sequence as the Column Heading, and first of Job as the Value? You might also
want to include all of the unique Sequence values in the Column Headings
property.

 

[PointerMan]

Duane,
I haven't tried that yet, because honestly I'm not very familiar with
Access. I'm using it now because it holds all of my data, so I'm just trying
to reorganize it so that it'll work in Excel. I'll look up the crosstab
query to see if I can get something to work. Thanks for helping!

Spencer

 

[Duane Hookom]

If you are using Excel, you can create a pivot table linked to your Access
table. This should work as long as your total number of unique Number values
don't exceed the number of rows allowed in Excel.