making your query results into a table

[Matthew Kramer]

Once you have created a table through a query, is there a way to make
that dataset into an Access "table" rather than a table/dataset
generated by a query?

Maybe someway to cut and paste the results of the query into a table?

Also, if you're in a table and you run a filter and have the rows you
like - is there a way to copy those results into a new table? I know in
excel, after you've done a filter and have the rows you're looking for,
you could do a "go to", special, visible cells only, copy, paste into a
new spreadsheet. Is there some way to do this in Access?

Thanks.

Matthew

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Jeff Smith]

While in the Query's design view, go to Query>Make-Table Query, Type in the
name you want the table to be saved as and then go to Query>Run. Click Yes
to all the prompts.

Jeff

"Matthew Kramer" <mk********@hotmail.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

Once you have created a table through a query, is there a way to make
that dataset into an Access "table" rather than a table/dataset
generated by a query?

Maybe someway to cut and paste the results of the query into a table?

Also, if you're in a table and you run a filter and have the rows you
like - is there a way to copy those results into a new table? I know in
excel, after you've done a filter and have the rows you're looking for,
you could do a "go to", special, visible cells only, copy, paste into a
new spreadsheet. Is there some way to do this in Access?

Thanks.

Matthew

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bas Cost Budde]

Matthew Kramer wrote:

Once you have created a table through a query, is there a way to make
that dataset into an Access "table" rather than a table/dataset
generated by a query?

Maybe someway to cut and paste the results of the query into a table?

Unless you want a tryout set of records, to apply some destructive
actions to, and to provide an Undo action, I reccomend you *don't*
duplicate your data this way.

What is it you are trying to achieve?