• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

Reverse Data

Folks I have a table in an access database that I need create a new table with that data.

Attached is a spreadsheet with two tabs, the first one is a sample of what the table looks like and the second tab is what I like the new table to look like...

Any assistance is appreciate...
Example-Data.xlsx
0
TonyEF
Asked:
TonyEF
  • 2
  • 2
1 Solution
 
chaauCommented:
With the situations like this you need to do this query:
SELECT [Account Number], #7/1/2000# AS [Date], [7/1/2000] AS [Value] From Original_Table
UNION ALL 
SELECT [Account Number], #8/1/2000# AS [Date], [8/1/2000] AS [Value] From Original_Table
UNION ALL 
SELECT [Account Number], #9/1/2000# AS [Date], [9/1/2000] AS [Value] From Original_Table
etc..

Open in new window

Once you are happy with the query results and have populated all your UNION cases you can select Query Type as Make Table and run the query
0
 
TonyEFAuthor Commented:
this is is the out put, however I like the query to make a new table...
0
 
chaauCommented:
Save your query as a Query1. Create a new query as a "select * from Query1". Save it as Query2. Open Query Designer for Query2. In the Query Type select "Make table" You will be asked to type a new table name. Run the query2 (there is a button "Run")
0
 
TonyEFAuthor Commented:
Excellent, thank you for your assistance....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now