Moving Rows of data into Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two queries that I currently use to find data from a table then i sort
it into a manner that is useful to me. They are both just select queries, the
first gets the information and it has a column that is a TrackingPeriod, then
in the second I have to right forulmas to move the trkingper into columns so
I can then use it. I want to automate this somehow so I don't have to add a
tracking period each month. Help is appreciated.

This is what I do to seperate out the data:

May-04: IIf(([TkingPer]="May-04"),[SumOfTotalMaterial],0)

Jun-04: IIf(([TkingPer]="Jun-04"),[SumOfTotalMaterial,0)

And so on for each month
 
Steven said:
I have two queries that I currently use to find data from a table then i sort
it into a manner that is useful to me. They are both just select queries, the
first gets the information and it has a column that is a TrackingPeriod, then
in the second I have to right forulmas to move the trkingper into columns so
I can then use it. I want to automate this somehow so I don't have to add a
tracking period each month. Help is appreciated.

This is what I do to seperate out the data:

May-04: IIf(([TkingPer]="May-04"),[SumOfTotalMaterial],0)

Jun-04: IIf(([TkingPer]="Jun-04"),[SumOfTotalMaterial,0)

And so on for each month
Click to expand...

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

Use cross-tab queries. Read the Access Help article "Create a select or
crosstab query" for more info. In the A2K2 Help's Contents tab, the
hierarchy is:

Queries
Creating Queries
Select and Crosstab Queries
Create a select or crosstab query

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

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

iQA/AwUBQjCvW4echKqOuFEgEQL99wCeJ5htvJjVxvwUbjZiDdULPSq7rKAAnRTN
TCsnuBKBpIchs3KJUrBztwcg
=FDSk
-----END PGP SIGNATURE-----
 
Back
Top