Make a table from crosstab query

[Razor]

Hi,

In Access 2000, a query can be EITHER a "make-table"
or "crosstab," not both.

What is the best way of sendng the resultset of a crosstab
query directly to a table?

I'd like to do this without pasting the resultset into
Excel and importing back to Access.

Thanks,

Razor

 

[John Vinson]

Hi,

In Access 2000, a query can be EITHER a "make-table"
or "crosstab," not both.

What is the best way of sendng the resultset of a crosstab
query directly to a table?

Well, first ask yourself, why should I do this? You can base a Form, a
Report, another Query, an Export, etc. directly on the Crosstab query.
What benefit do you gain by storing (formally redundant) data in a
Table?

But to directly answer your question, just save the Crosstab query and
create a MakeTable query, using the stored crosstab query as its
source. A MakeTable query need not be based directly on a table or
tables; it can be based on another Query.

 

[Dennis Schmidt]

Hi Razor,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

Create an addtional query based on the crosstab query. You can change this
query into a MakeTable query.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support

 

[Zeppo]

In Access 2000, a query can be EITHER a "make-table"
or "crosstab," not both.

What is the best way of sendng the resultset of a crosstab
query directly to a table?

I'd like to do this without pasting the resultset into
Excel and importing back to Access.

Silly isn't it.If you migrate to S2k you can use the
RAC utility instead of the Access crosstab.Then you
won't have such problems.

RAC v2.2 and QALite @
www.rac4sql.net