Add Update Records

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

INSERT INTO Table_B
SELECT Table_A.*
FROM Table_A LEFT JOIN Table_B ON Table_A.Join_Field=
Table_B.Join_Field
WHERE Table_B.Join_Field Is Null

that will return and insert the records in A that are not
in B.
I hope the table A and B are the same build.

>-----Original Message-----
>I Have 2 tables
>
>Table A
>Table_B
>
>Ana created an update query
>
>Table A has new data that is required to update items in
table B.
>
>Table A has 20 records, Table B has 19
>
>When I run the update, Table B still has 19 records and
the new record added
>is ignored.
>
>Anyone help me with this add/update
>
>TIA
>
>Les
>
>
>
>
>.
>
.

Relevant Pages

  • Re: Null value problem
    ... >> But keep getting #error message in the field, ... >> TIA ... Prev by Date: ...
    (microsoft.public.access.reports)
  • WTD: HP1930 screen
    ... My lcd is broken but the touch screen is ... TIA ... Les ... Prev by Date: ...
    (comp.sys.handhelds)
  • Update Problem
    ... Anyone tell me why this update query will not work? ... TIA ... Les ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Page Breaks
    ... Anyone tell me how I can force a subreport onto a new page if the values are ... TIA ... Les ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: Combobox help
    ... > I want the following THREE options to be available from the combobox [and ... > TIA ... > Sue Compelling ... Prev by Date: ...
    (microsoft.public.access.forms)