Get value from query to update another another table

I have a query that simply slelcts the min value of a specified field
from one table, I want to take that value to update a field in
annother table, just can not figure it out.

.

Relevant Pages

  • Re: last, first, etc
    ... FIRST and LAST "...simply return the value of a specified field in the ... first or last record, respectively, of the result set returned by a query. ... > Product Quantity Price Date ... > I've tries using the LAST aggregate function in the QBE but the results ...
    (microsoft.public.access.queries)
  • The specified field could refer to more than one table error with curious but inadequate fix
    ... I have a query that is being created in code. ... "The specified field 'Acct' could refer to ... the 'Acct' field is fully qualified in the ... PerDiem, GLAcct, RegPmtAmnt, OrigNumPmts, NSFCount, LastNSFDate, ...
    (comp.databases.ms-access)
  • Re: Find last record in date field for each device in the device f
    ... The function returns the value of a specified field in the first or last ... record, respectively, of the result set returned by a query. ... about "totals", right-click in the query designer and select the ... the exact SQL statement since I don't know your table names, ...
    (microsoft.public.access.queries)
  • Re: Delete records containing certain info
    ... I tried what you said and it worked as a select query but I get an error ... "Duane Hookom" wrote: ... MS Access MVP ... contains certain "text" in a specified field? ...
    (microsoft.public.access.queries)
  • Only updating a field once when running same query multiple times
    ... Kind of hard to put in a subject header for this. ... I want to run a query so that it picks up which records have ... today's date in a specified field. ... access would complain that it's not a valid statement or somesuch ...
    (microsoft.public.access.queries)