Acess database 2003

S

S Penney

I'm trying to save a query (select) as a table but there is no option to save
as table.... just query, form, report or data acess page.
 
K

Ken Snell \(MVP\)

Yes, that is correct. If you want to save the data from the query, turn the
query into a MakeTable query and then it'll write the data into a new table
for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter from form 5
make table query 3
SQL or maybe a hardware issue for finding lowest Repair order date or mileage 4
problem with query 1
access database query 1
Insert query from Access 97 to 2002 4
can't save modified query 2
Make Table Query in NEW ACCESS file 1

Top