Turn crosstab into a table...

[MSherfey]

In this post I learned a better way to organize my data using a crosstab query. Now I need to turn that crosstab query into a table so I can properly use it in other queries (I need the one-to-many the crosstab creates). However, the only way I can do that is to export the crosstab to Excel, then re-import it as a table. Is that correct?

Is there a way to turn a crosstab query into a table so it can be used in relationships?

 

[boblarson]

Is there a way to turn a crosstab query into a table so it can be used in relationships?

Put it into another query which you set as a Make Table query.

 

[MSherfey]

Worked like a champ! Thank you!

Why not allow it to be done directly from a crosstab? I find that if I have to go through multiple steps to get something done it usually means I'm doing it the hard way

 

[boblarson]

Worked like a champ! Thank you!

Why not allow it to be done directly from a crosstab? I find that if I have to go through multiple steps to get something done it usually means I'm doing it the hard way

I know it would be great to be able to, but Access doesn't seem to like turning a Crosstab into an append/make table query as well. So, nesting it inside an append/make table query seems to go over better.