Create a table from a crosstab query

[Newbie12345]

I have a crosstab query which gathers data from a regular table and creates columns for the months in the year with volume for each month. I want to be able export/send the data to a brand new table, which would keep the new formating with the months as fields.

So basicall i want to create a table from that crosstab query that looks identical to the query. I tried using a make-table query but this just puts all the data back into the way the original table was, without column fields for the months.

[nico5038]

Use the save crosstable query as the input for your Make-table query.
(Second tab when defining a new query holds the queries you can use)

Nic;o)

[im dj]

Use the save crosstable query as the input for your Make-table query.
(Second tab when defining a new query holds the queries you can use)

Nic;o)

im a newbie on doing cross-tabs and make-tables...how do I do this?

Thanks!

[rwickberg]

save a crosstab to a new table

Maybe the previous instructions were a bit unclear.

You have a crosstab you like. Don't try to change that crosstab to a make-table, because then it won't pivot any more. Instead, save that crosstab. Now create a separate make table query. Use the crosstab as the input to this second query, and simply select all fields from the crosstab. Now, when you run this make table query, it'll run the crosstab query, then make a table based on the results.

does that make sense now?

[AtLarge]

Does for me. Thanks rwickberg!