Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

convert query results to table

Status
Not open for further replies.
robdunfey

robdunfey

Technical User
Apr 26, 2002
110
GB
Hi,

I would like to convert the results of a query to a Microsoft Access table, how is the simplest way to do this?

Many Thanks,

Rob
 
Sort by date Sort by votes
In the Query Design , Click on the "QUERY" tab and select "MAKE TABLE QUERY" , run the query and you have the Table
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Question
Help with a Query. 1
Replies
10
Views
231
strongm
strongm
serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
519
Andrzejek
Andrzejek
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
2K
dhookom
dhookom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
2K
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
697
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top