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.
--
Duane Hookom
Microsoft Access MVP
"PointerMan" wrote:
[Quoted Text] > 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" wrote:
>
> > 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.
> >
> > --
> > Duane Hookom
> > Microsoft Access MVP
> >
> >
> > "PointerMan" wrote:
> >
> > > 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!
|