Can you create a table from the output of a query?
in [Queries]
|
Prev: Record Count
Next: Query Join on Multiple Field Indexes
From: BobC on 3 Jul 2008 19:37 Using MA 2007 ... I would like to create a new table from the output of a query. Can this be done ... if so how? Thanks Bob
From: Douglas J. Steele on 3 Jul 2008 19:42 You can create an INSERT INTO query based on the query you've created. You'd create it the same as any other Make Table query, except you'd base it on your query, not a table. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "BobC" <Bob.NoSpammm(a)cox.net> wrote in message news:1pdbk.11751$Fj5.8867(a)newsfe23.lga... > Using MA 2007 ... > I would like to create a new table from the output of a query. > Can this be done ... if so how? > Thanks > Bob
From: Christopher Robin on 3 Jul 2008 19:47 Yes it can. In the Query Designer, just select the Make Table button on the ribbon and provide a table name. "BobC" wrote: > Using MA 2007 ... > I would like to create a new table from the output of a query. > Can this be done ... if so how? > Thanks > Bob >
From: Jeff Boyce on 3 Jul 2008 19:49 Douglas has provided a "how to"... Now, I'm curious as to "why", as in "why do you believe you need 'to create a new table from the output of a query'"? Regards Jeff Boyce Microsoft Office/Access MVP "BobC" <Bob.NoSpammm(a)cox.net> wrote in message news:1pdbk.11751$Fj5.8867(a)newsfe23.lga... > Using MA 2007 ... > I would like to create a new table from the output of a query. > Can this be done ... if so how? > Thanks > Bob
From: BobC on 3 Jul 2008 19:51
That was certainly quick! Thanks much! Christopher Robin wrote: > Yes it can. In the Query Designer, just select the Make Table button on the > ribbon and provide a table name. > > "BobC" wrote: > >> Using MA 2007 ... >> I would like to create a new table from the output of a query. >> Can this be done ... if so how? >> Thanks >> Bob >> |