How can we convert a crosstab query to a table?

J

John Spencer

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
..
 
Top