Saving a query (Access 2000)

Topic

New Reply

If I want to take the values returned by a query and save them in a table, how do I do so?

Thanks

Reply | Quote

Replies

It depends on what exactly you want to do. One way is to turn the query into a Make-table query. That will give you a table with the same fields as the query and with the records returned by that query at that particular time. Does that answer your question?

Reply | Quote

Thanks! That works great except for the message asking you if you’re sure you want to delete the table every time you want to run the query. (I have the option set so that it doesn’t ask me on delete queries, but that doesn’t take care of this annoying message) I’m trying to keep things as simple as possible for the user.

Reply | Quote

How will the user be running the make-table query? If it’s called from a macro, add a SetWarnings action before and after the OpenQuery. Turn if off before the OpenQuery and back on afterward. If you’re calling it from VBA code, use a DoCmd.SetWarnings instead.

Reply | Quote

Great! Thanks for the help! (I’ll probably be posting more questions because this project is due in a week!)

Reply | Quote