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

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.

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.

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.