Exporting Data from a Crosstab Query to an Access Table

  • Thread starter Thread starter Jim Pockmire
  • Start date Start date
J

Jim Pockmire

There are probably several ways to do this, including using pivot tables. Is
there a simple way to create an Access table from a crosstab query?
 
Jim said:
There are probably several ways to do this, including using pivot tables. Is
there a simple way to create an Access table from a crosstab query?
Click to expand...

Use the cross-tab query as the data source for a make table query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make-table query with around 2 ml records taking too long 0
View raw data behind crosstab query 4
crosstab query child table count 5
Crosstab query as data source for update query 7
Transpose Data that involves subquery 0
Insert a crosstab to temp table 4
insert a crosstab in to temp table query 2
need help making a query (crosstab instead of Pivot tables?) 2

Back
Top