querry

[Eva]

One tricky question
I have a two tables - one is a source data and the second one is a new
data.
The two have same column headings.
The new data table can have new records or same records same as source data,
but with some changes

For example

Record Table Heading Data
1 Source Department Marketing
1 New Department Finance

I need to update the source data with the new records and update all the
information that has discrepancies in new data
I tried to set up a querry (miscrosoft querry) with no luck.
How to do it?

 

[Jeff Boyce]

Eva

It sounds like your two tables are identical in structure. If so, why? You
mentioned that "one

is source data and the second one is a new
data". That describes how you are using the tables, not why you are using
two.

If you need to distinguish between records of type 1 ("new") or type 2
("existing"), use a single table, add a new field to hold "type", and put
the "type" of each record along with the record, not as the name of a
separate table.

Regards

Jeff Boyce
Microsoft Office/Access MVP