to join columns

[sprbc]

Hello everybody,

I have a table with 9 columns and 4 rows as I show on the following picture.

I would like a query to join the columns with the same field as I show on the following picture.

I have windows 7 and access 2013

Thank you so much.

 

[Micron]

Try

Select [Item 1] As Item, [Price 1] As Price, [Units 1] As Units FROM tblYourTable
UNION ALL
Select [Item 2], [Price 2], [Units 2] FROM tblYourTable
UNION ALL
Select [Item 3], [Price 3], [Units 3] FROM tblYourTable;

If you really have spaces in your field names, and you really have your data laid out that way, you've made 2 serious design errors at least.

 

[sprbc]

Thank you Micron for the code, it works perfectly.

 

[sprbc]

Solved

 

[Micron]

This is cross posted here
to join columns

vis65: you need to read this, lest you find that further issues you post go unanswered. I will add this to your Acces forum post as well.
Excelguru Help Site - A message to forum cross posters

 

[sprbc]

This is cross posted here
to join columns

vis65: you need to read this, lest you find that further issues you post go unanswered. I will add this to your Acces forum post as well.
Excelguru Help Site - A message to forum cross posters

I am really sorry Micron. I really read the forum rules but I have never heard about the forum cross posters. I just read <<http://www.excelguru.ca/content.php?184>>. I apologize. Thanks for your warning.