crosstabe question

[dlb1228]

is there a way to take a crosstab query and make a new table out of it?
normally you can take a select query and do a make table. but can you take
a crosstab and do this?

 

[Duane Hookom]

You can use a saved crosstab query as the source for a make table query.

 

[Jerry Whittle]

Sure. Save the crosstab query. Next create a Select query based on the
crosstab. Run it to make sure that the data looks right. Convert this new
query to a Make Table and run it.