Add data to specific fields within existing records in a table from another table.

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Taz (anybody_at_anywhere.com)
Date: 02/04/04 

Date: Wed, 4 Feb 2004 18:34:47 -0500

Hello, I would like to use a query or other method to add data from one
table to specific fields in existing records in another table. I tried to
use an append query but this will only add new records to the other table,
not add data to fields in existing records.

Example: TableA and TableB

Table A has fields for "Customer ID", "Address 1", "Address 2" and "Email"
All the fields except "Email" contain data.

TableB has two fields "Customer ID" and "Email"-both contain data.

I need to add the data "email" from each record in TableB to the matching
field in TableA based on "Customer ID" which is the primary key in each
table.

Please help. Thanks.

Relevant Pages

  • Re: Subselect Query Problem
    ... I'm testing what you posted in the Query area ... Table A actually uses an autonumber primary key. ... >FROM tableA LEFT JOIN (SELECT project, status FROM tableB WHERE ...
    (microsoft.public.access.queries)
  • Re: How easy is this?
    ... > I am trying to create a form based on a query that is updatable and ... > TableA with 3 Fields: ... > and TableB with 2 Fields: ... ,CONSTRAINT pk_TableA_10232005_2 PRIMARY KEY ...
    (microsoft.public.access.queries)
  • Re: Problem with Dual subselect
    ... So I've constructed a UNION QUERY as follows. ... FROM TABLEA AS A ... B.STATUS_DATE FROM [TABLEB] As B ... A Lookup property on the foreign-key field ...
    (microsoft.public.access.queries)
  • Re: use a result as a FIELD in the design grid
    ... I have a key TableA that maps each station's flow (and ... Station: FlowField: TankLevel: PumpRun: ... OK, now from the previous query, I know that the FlowField ... So in a new query grid where TableA is linked to TableB ...
    (microsoft.public.access.queries)
  • Re: Finding matching records
    ... >> An inner join in a query will return only records where the join ... Suppose you have two tables, TableA and TableB, with these fields: ... A_ShouldMatch has a match in the B_ShouldMatch field in TableB. ... create a new query in Design View and add both TableA and TableB to the ...
    (microsoft.public.access.modulesdaovba)