Make Table

[princessdb]

Can anyone tell me is it possible to get a crosstab query to save its results in a table? Please, Thanks

[r937]

not directly, no

however, if the volume of data is not too big, once you see the crosstab query results in datasheet view, click on the top left corner to highlight all cells, copy, then go to table, new, datasheet view, click on the top left corner, paste, et voila

don't close the crosstab query results datasheet view just yet, because you now need to save the new table just created, open it again in design view, and systematically rename the columns from Field1, Field2, Field3, etc., to new column names that reflect the values that got cross-tabbed in that sequence

if you know what i mean

[r937]

forget the previous post, this is what you want to do --

select * into [new table] from [your crosstab query]

please note, this solution was provided today on, ahem, another forum, by a poster known as "pootle flump"

and now that i've seen it, i realize that i should've known it all along, so it shall henceforth be my solution too