472,362 Members | 2,092 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,362 software developers and data experts.

"Cross Tab" Table to "Simple" Query

I have a table with the following Fields:
Article and 8 fields that are Dates. Under each date is a quantity.

I would like to run a query that would have only 3 columns:
Article, Date and Quantity

Thank you very much
Sep 6 '07 #1
1 1452
1,923 Expert 1GB
I have a table with the following Fields:
Article and 8 fields that are Dates. Under each date is a quantity.

I would like to run a query that would have only 3 columns:
Article, Date and Quantity

Thank you very much
Try a union query like this, but use something other than Date as the name of your datefield in your table because Date is a reserved word in Access:
Expand|Select|Wrap|Line Numbers
  1. "Select article, datefield1 As datefield, quantity From YourTable
  2. Union Select Article, datefield2 As datefield, Quantity From YourTable
  3. Union Select Article, datefield3 As datefield, Quantity From YourTable
  4. Union Select Article, datefield4 As datefield, Quantity From YourTable
  5. Union Select Article, datefield5 As datefield, Quantity From YourTable
  6. Union Select Article, datefield6 As datefield, Quantity From YourTable
  7. Union Select Article, datefield7 As datefield, Quantity From YourTable
  8. Union Select Article, datefield8 As datefield, Quantity From YourTable";
Sep 6 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Mark Hahn | last post by:
Ville Vainio came up an idea for one final tweak of the tab/space indent algorithm we are using in Prothon, and the final result surprised me, in that it directly addresses the problem of mixed...
by: Dario de Judicibus | last post by:
I wish to create two simple layouts by using only HTML, CSS and the minimum JavaScript as possible. Layouts should be "elastic" (no fixed widths and heights) and cross-browser enabled. The first...
by: Jim Hubbard | last post by:
It seems that Microsoft not only does not need the classic Visual Basic developer army (the largest army of developers the world has ever seen), but now they don't need ANY Windows developer at a...
by: Oscar Thornell | last post by:
Hi, I would like to create a tab in MSN Messenger like an addin...that uses the Messenger interface... My idea is to export data from a Web Service on wich the users can access information via...
by: mdh | last post by:
I wrote a little insignificant program, to help me write a more significant one!!...that was supposed to print all Ascii values from 0 to 127: >>>> #include <stdio.h> # define UPPER_LIMT 127...
by: Rob R. Ainscough | last post by:
I'm using a BackgroundWorker to perform a file download from an ftp site. Per good code design practices where I separate my UI code from my core logic code (in this case my Download file method in...
by: frk.won | last post by:
I am interested in learning how to use the VS 2005 code snippets. However, I wish to know what are the best ways to source control the code snippets? Are there any source safe/subversion...
by: Peter Duniho | last post by:
Okay, I'm guessing I'm overlooking something simple here, but I'm obviously not going to find it. Someone please tell me the exact name of the "Cross-thread operation not valid" MDA, as seen in...
by: Anze | last post by:
Hmmm... anyone? :) Anze Anze wrote:
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.