How can we convert a crosstab query to a table?

  • Thread starter Thread starter Guest
  • Start date Start date
Save the crosstab query and use the saved query as the source for a make
table query.

-- Open a new query
-- Click on the queries tab
-- Find the crosstab query and select it
-- Select Query: Make Table Query ... from the menu
-- Input the name for the new table
-- Select Query: Run from the menu

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

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
Crosstab 3
Creating a table from series of Crosstab queries 3
crosstab query without calculations 4
Crosstab query as data source for update query 7
Insert a crosstab to temp table 4
cross tab query label change 1
crosstab query child table count 5

Back
Top