query to new table

[Big X]

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.

SELECT vinno, make, ownername, address, suburb, state, pcode
FROM [FULL]
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.

[Big X]

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

 SELECT vinno, make, ownername, address, suburb, state, pcode INTO iload
 
      FROM [FULL]
 
      WHERE make like '*iload*';

[JustJim]

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

 SELECT vinno, make, ownername, address, suburb, state, pcode INTO iload
 
      FROM [FULL]
 
      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

[Big X]

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.