Crosstab to table query

[waldi]

Hi, I made a crosstab (1.png) query from data (2.png), then I manipulated the data (more price breaks). Now I need to change the data (1.png) back into the format in image 2.png. Unfortunately, here I´m completely lost. Any suggestions, thanks?

[CJ_London]

why not just copy your crosstab sql to a new query, then change to a group by/append query and use criteria to exclude the columns you don't want?

otherwise you will need multiple append queries, one for each column required

[isladogs]

I don't understand.
Your crosstab was based on a table or query -
Crosstabs are read only so if you added extra price breaks you either:
a) edited the original table so you still have that data
b) used a make table query based on your crosstab & then deleted the original

If a) then you already have what you need
If b) then you will need to do something like ajax described with a series of append queries for 1 column of From_Qty data at a time.
Easy but repetitive