Re: UPDATE Query

From: Gerald Stanley (gcstanley_at_dsl.pipex.com)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 05:40:34 -0700

Jeff

That was the line I was taking to solve Darren's problem
but when I simulated it, I got the error message 'Operation
must use an Updateable Query'. The same error message
appeared when I ran it with the first query 'embedded' in
the second and agin when I had saved the first query. Any
ideas why?

Gerald Stanley MCSD
>-----Original Message-----
>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: IIF Statement to calculate aging buckets
    ... If Access says it's too complex, Access can't understand it -- incorrect may ... Now create a second query, ... all the fields from the first query, then add your original IIFstatement. ...
    (microsoft.public.access.queries)
  • Re: how do i count consecutive records with a field value >=1
    ... The first query consider for each record how many records in table ... The second query keep only the ranks where bal <0. ... but i don't have a clue how your sql got the results i needed. ...
    (microsoft.public.access.queries)
  • Re: IIF Statement to calculate aging buckets
    ... >> parameter needs to be defined as Date Type in the query. ... >> Jeff Boyce wrote: ... >>> Now create a second query, ... >>> all the fields from the first query, ...
    (microsoft.public.access.queries)
  • Re: IIF Statement to calculate aging buckets
    ... > parameter needs to be defined as Date Type in the query. ... >> Now create a second query, ... >> all the fields from the first query, then add your original IIFstatement. ...
    (microsoft.public.access.queries)
  • Re: IIF Statement to calculate aging buckets
    ... > parameter needs to be defined as Date Type in the query. ... > Jeff Boyce wrote: ... >> Now create a second query, ... >> all the fields from the first query, ...
    (microsoft.public.access.queries)