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

    Reversing Crosstab Table (Access 2000)

    I have a crosstab table that shows different locations as column heading and sales teams as row heading and $sales as the value. Is there a way to turn a crosstab table back into a regular table with three fields: sales team, location and $sales ?

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

    Re: Reversing Crosstab Table (Access 2000)

    I'm sorry, but there's no such thing as a crosstab table. There are crosstab queries and there are pivot tables. Neither of these change the way the data is actually stored, so the data is still there in its original form and can be pulled out differently. If you explain further, someone will be able to help.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    174
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reversing Crosstab Table (Access 2000)

    Ok, what I meant is I have a table with data arranged as a crosstab querry. Anyway to change that table in the format of a regular table ?

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

    Re: Reversing Crosstab Table (Access 2000)

    Not automatically. A crosstab is a flat table. If you want to convert the data into a relational table, you're going to have to design the table first and then do a series of append queries to get the data out of the other table and into the new one.
    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
  •