"Cross Tab" Table to "Simple" Query

[Luis Freitas]

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

[puppydogbuddy]

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:

"Select article, datefield1 As datefield, quantity From YourTable
Union Select Article, datefield2 As datefield, Quantity From YourTable
Union Select Article, datefield3 As datefield, Quantity From YourTable
Union Select Article, datefield4 As datefield, Quantity From YourTable
Union Select Article, datefield5 As datefield, Quantity From YourTable
Union Select Article, datefield6 As datefield, Quantity From YourTable
Union Select Article, datefield7 As datefield, Quantity From YourTable
Union Select Article, datefield8 As datefield, Quantity From YourTable";