RE: Change target for a query?

From: geeksdoitbetter (geeksdoitbetter_at_discussions.microsoft.com)
Date: 12/30/04 

Date: Thu, 30 Dec 2004 08:53:04 -0800

if the two tables have all the same fields ...

first, make a copy of your query and rename (Events_2005 Query)

open Events_2005 Query in design view

add Events_2005 table (query menu, show table)

for each field in the query, change the information in Table: using the drop
down menu found below each Field: (you'll see these words to the extreme left)

there should be no need to add/delete fields or modify the exisiting criteria

then, delete Events_2004 table (right click on the table, remove table)

"LeighB" wrote:

>
> Hi,We have an events database, with a number of queries to extract subsets
> of data from the whole year events table.
> We are now finished with Events_2004, and have created a new table
> Events_2005.
> Is it possible to use the existing queries and point them to the new table,
> or do we have to re-create all the queries?
> Thanks
> Leigh

Relevant Pages

  • Re: Is this join valid?
    ... > complex set of tables and queries, but I've boiled down the behavior ... you describe a problem with the Design View that really should not ... affect what happens when running a query from ASP. ... > the SQL view after creating the query in Design View. ...
    (microsoft.public.inetserver.asp.db)
  • seeming quirk with creating new queries from a2000 db /WinXP access/WinXP OS
    ... There is a query property when in the builder ... >from this dbase in Design View. ... >Existing queries that he believes he created as recently ...
    (microsoft.public.access.queries)
  • Re: Stopping query when opening in design view
    ... Within the article is gves a tip about optimizing a query by recompiling it ... by opening it in design view. ... > Microsoft Security Bulletin MS03-026? ... Each of the underlying queries are looking ...
    (microsoft.public.access.queries)
  • Re: save table records from select tempquery
    ... Append query help is right choice for my case. ... my accountant's room) and trying understand best design solution ... sum totals or recall selected aggregated totals as necessary for later ... No, "MakeTable" Queries, just as the name suggests, make an entirely new ...
    (comp.databases.ms-access)
  • Re: Displaying Query Results on a Form
    ... I designed the main table in 'design view'. ... I have built many queries to calculate 'statistical' results. ... "Jeff Boyce" wrote: ... How you query depends on how your data is ...
    (microsoft.public.access.gettingstarted)