Convert Query into Table 1

[robbt]

Hi,
Is it possible to convert a query into a table using some some of marco?

 

[johnherman]

What database are you using? Is it a SQL query?

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[johnwm]

If it's SQL look at the Insert Into keywords

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[robbt]

yes, its a SQL Query, i'm using ms access to do the db. I've looked at the actions for a query and there is no Insert into keywords action. Where can I find it?

 

[SQLSister]

in Query designer, click the query type button and choose a Make table query.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[robbt]

thanks, although there is no make table type query. I only have design view, simple query wizard, crosstabwizrd, find duplicates query wizard and find unmatched query wizard. im using ms access 2003

 

[SQLSister]

Go to design view. There is a button called Query Type. Make table is one of the choices.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief