A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can we convert a crosstab query to a table?



 
 
Thread Tools Display Modes
  #1  
Old September 12th, 2007, 10:38 AM posted to microsoft.public.access.queries
senthil
external usenet poster
 
Posts: 24
Default How can we convert a crosstab query to a table?

How can we convert the output of an crosstab query to a table.
  #2  
Old September 12th, 2007, 12:52 PM posted to microsoft.public.access.queries
John Spencer
external usenet poster
 
Posts: 7,815
Default How can we convert a crosstab query to a table?

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

"Senthil" wrote in message
...
How can we convert the output of an crosstab query to a table.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.