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
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