By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,482 Members | 2,438 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,482 IT Pros & Developers. It's quick & easy.

query to new table

P: 42
This seems like there would be a simple save as new table in access to me but I cant seem to find it. I am running a query to get specific results using sql. How do I save those results as a new table. I just need to seperate two groups of information and use it for a mail merge.

Expand|Select|Wrap|Line Numbers
  1. SELECT vinno, make, ownername, address, suburb, state, pcode
  2. FROM [FULL]
  3. WHERE make like '*iload*';
Is there a command to create a table and insert query results into that new table first ?

I can do this just by using excell and filtering then cut and past a new sheet but I prefer to be able to do it all in access.

Thanks for your help.
Apr 15 '08 #1
Share this Question
Share on Google+
3 Replies


P: 42
Ow man I spend a hour looking on google for solution so I jump on here and post. 2 minutes later I find a solution lol. Why that alway happen :).


Expand|Select|Wrap|Line Numbers
  1.  SELECT vinno, make, ownername, address, suburb, state, pcode INTO iload
  2.  
  3.       FROM [FULL]
  4.  
  5.       WHERE make like '*iload*';
Apr 15 '08 #2

JustJim
Expert 100+
P: 407
Ow man I spend a hour looking on google for solution so I jump on here and post. 2 minutes later I find a solution lol. Why that alway happen :).


Expand|Select|Wrap|Line Numbers
  1.  SELECT vinno, make, ownername, address, suburb, state, pcode INTO iload
  2.  
  3.       FROM [FULL]
  4.  
  5.       WHERE make like '*iload*';
Hi,
Well yes you can do that, but why make a new table just for a mailmerge? Why not use the query as a mailmerge source? Write the query that gets the data you want and save it. It is now available as a mailmerge source. The advantage, of course is that if the data in your main table changes, the query reflects those changes where the new table would have to be "re-made" in order to do that.

Jim
Apr 15 '08 #3

P: 42
I actually did try that. When I preformed the merge using the query it had no data in it when I was in word. I checked back in access and loaded the query and it was working fine. Not sure what the problem there is. I have a play around with it.
Apr 16 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.