Saving a query as a table????

[pdbowling]

Hi all, sorry about the cross posts before...

Can I save the results of a query as a table that will show up in my Tables list? Should be able to but don't know the keywords very well. Thank all.
PB

 

[Mile-O]

Why would you want to if the query already returns the results you'd need?

Anyway, have a look at Make Table queries.

 

[pdbowling]

Yeah

My boss wants me to generate Excel Graphs that will be querying from the query and I just thought that a query into a table would be more simple than a query into a query. Man, that's a tongue twister almost. Thanks a bundle.
PB

 

[The_Doc_Man]

Export the query to Excel directly. That's perfectly legal. I do it all the time.

But besides that, there is nothing wrong with a query of a query unless you are running an old 80486 at 33 MHz in 64 Mb with a 500 Mb hard drive...

 

[pdbowling]

Alright!

Thanks for all of the feedback.
A query of a query sounds like something I need to look in to for another project I've got brewing. The database is not shared thankfully so I can create and destroy any tables I choose. That's helpful. I will note the creation of tables being problematic in shared dbs.

About exporting to excel. That was what I originally tried to do but something really odd happened. After the outputTo command, Access erased the query???? I'd go back and look at the query and all it would say is SELECT;

I'm at a loss for that one. The query was 4 lines long and uuuugly. Left join too.

Thanks everyone for all your help.
PB