Re: UPDATE Query

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 04:58:48 -0700

Darren

One approach would be to "chain" together your queries. First, the query
you already have derives the values you want to use to update with. The
second part would be to write a second query that uses the first query (as
if it were a table) and performs the update.

You'd only need to run the second query directly, as it would run the first
to get its values. 

-- 
Good luck
Jeff Boyce
<Access MVP>

Relevant Pages

  • Re: How to benchmark Access queries?
    ... > to a more robust engine (e.g. SQL Server)? ... > Given the myriad of ways folks can design data structures (and queries), ... rather than trying to do it all at once in a more complex query. ... I have a chain of 3 queries right now that is not performing ...
    (microsoft.public.access.queries)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Was: what does "serialization" mean?
    ... > the specific queries up front. ... that the NEXT time the query is run the query is fast, ... data base, don't know squat" when in fact the Donald clone doesn't ... >> WHATEVER would probably be a separate query to summarize total sales. ...
    (comp.programming)
  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Cluster synchronize
    ... queries per unit time. ... CPU is the ONLY bottleneck. ... increase in query capacity. ... queries that perform sequential I/O or queries performing random I/O. ...
    (microsoft.public.sqlserver.clustering)