Save a Query as a table?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

frank - 01 Aug 2006 18:48 GMT

Is that possible to save a query as a table which do need extra efforts in
Access 2003?

Reply to this Message

Klatuu - 01 Aug 2006 18:53 GMT

use a make table query

> Is that possible to save a query as a table which do need extra efforts in
> Access 2003?

Reply to this Message

frank - 01 Aug 2006 19:07 GMT

Sorry, I mean crosstab query and do not need extra efforts.

> use a make table query
>
> > Is that possible to save a query as a table which do need extra efforts in
> > Access 2003?

Reply to this Message

Klatuu - 01 Aug 2006 19:17 GMT

I have not idea what "do not need extra efforts" means.

> Sorry, I mean crosstab query and do not need extra efforts.
>
> > use a make table query
> >
> > > Is that possible to save a query as a table which do need extra efforts in
> > > Access 2003?

Reply to this Message

frank - 01 Aug 2006 19:27 GMT

Something is similar to that saving a form as a report by clicking 'saveas'
and select 'type' as report.

> I have not idea what "do not need extra efforts" means.
>
[quoted text clipped - 4 lines]
> > > > Is that possible to save a query as a table which do need extra efforts in
> > > > Access 2003?

Reply to this Message

Sreedhar - 01 Aug 2006 19:21 GMT

Sorry for the intrusion, but this post interested me in that, in a similar
situation, I made a Make-Table Query on my Cross-Tab Query and didn't give
much thought to a better approach.

Please comment.

Signature

Sreedhar

> Sorry, I mean crosstab query and do not need extra efforts.
>
> > use a make table query
> >
> > > Is that possible to save a query as a table which do need extra efforts in
> > > Access 2003?

Reply to this Message