Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    174
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Transforming Crosstab Type of Table into Simple TB (Access 2000)

    I have several tables in the format of a crosstab. Each table is a division of the company with row headings indicating products (there are over 300 of tehm) and column headings such as plants (over 60). The table itself contains the number of people working. These tables are updated monthly.

    I like to transform it into a regular table with four headings: division, plant name, product and number of people. Any way to do that ?

    TQ

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Transforming Crosstab Type of Table into Simple TB (Access 2000)

    The usual way to do this is to create a table with the structure you want and then use a series of append queries to append the records for each set of columns (fields) to the new table.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •