Re: Help with an update query??

If you are trying to add records to a table, you are not updating. You are
appending.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"T Miller" <TMiller@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FF8D997A-32F5-4ABD-95CF-5227AD18B488@xxxxxxxxxxxxxxxx
I have a main table that I need to add information from another table.
There
is a common field in both tables and I want to update a field name in the
main file from the other table. i.e.

common field: Ven_id

Main Table: ven_name
Second Table: ven_name

I want to take all of the names from the Second Table and add them to the
Main Table. I have tried an update query but nothing was done, so I
obviously did it wrong. help.....
--
Thomas


.

Relevant Pages

  • Re: Help with an update query??
    ... is a common field in both tables and I want to update a field name in the ... I have tried an update query but nothing was done, ... there is rarely any good reason to copy the name ... John W. Vinson ...
    (microsoft.public.access.queries)
  • Re: Table Set-up
    ... Microsoft Office/Access MVP ... relationship links Employee name and Employye ID ... Jeff Boyce wrote: ... I didn't notice a 'common field' in your description. ...
    (microsoft.public.access.gettingstarted)
  • Re: Form design
    ... form as a subform. ... Relate these two on their common field. ... Jeff Boyce ... Microsoft Office/Access MVP ...
    (microsoft.public.access.forms)
  • Re: update
    ... Do you have a common Field that uniquely identifies Record in both Tables? ... you can use and Update Query like:: ... with almost equal values except the entry for one field ... > Patrick Stubbin ...
    (microsoft.public.access.queries)
  • Update query
    ... I'm trying to write an update query by joining two tables ... together on a common field and updating the field in one ...
    (microsoft.public.sqlserver.datamining)