Query to update records

  • Thread starter Thread starter Caleb
  • Start date Start date
C

Caleb

Hi I have two customer tables, the first [Master_List] is much older but more
complete, however the newer one [NEWCompleteList] has more up to date email
addresses and fax numbers. I want to build a query that will update all the
Emails and Faxes in the Master_List with the Emails and Faxes in NEWComplete
List, but only for the records in NEWCompleteList that arent Null. This seems
so simple but Im having lots of troubles so any help would be greatly
appreciated. Thanks!
caleb
 
If you want this automated, it requires the identification of a primary or
unique key in each table that can be used to join them in a query. If you
don't have this, you can copy and paste from one to the other.
 
If you want this automated, it requires the identification of a primary or
unique key in each table that can be used to join them in a query. If you
don't have this, you can copy and paste from one to the other.
 
I dont have a primary or unique key that can identify a record from one list
and the same record from the other, and What do you mean copy and paste? I
cant copy a handfull of emails in access and paste the into another table for
two reasons, one access wont let me and two the records wouldn't be lined up
right and I would be copying emails to the wrong records!
Do you have any other suggestions? I dont believe I can add a primary key
because they wouldn't be the same for both tables.

Duane Hookom said:
If you want this automated, it requires the identification of a primary or
unique key in each table that can be used to join them in a query. If you
don't have this, you can copy and paste from one to the other.

--
Duane Hookom
Microsoft Access MVP


Caleb said:
Hi I have two customer tables, the first [Master_List] is much older but more
complete, however the newer one [NEWCompleteList] has more up to date email
addresses and fax numbers. I want to build a query that will update all the
Emails and Faxes in the Master_List with the Emails and Faxes in NEWComplete
List, but only for the records in NEWCompleteList that arent Null. This seems
so simple but Im having lots of troubles so any help would be greatly
appreciated. Thanks!
caleb
Click to expand...
Click to expand...
 
I dont have a primary or unique key that can identify a record from one list
and the same record from the other, and What do you mean copy and paste? I
cant copy a handfull of emails in access and paste the into another table for
two reasons, one access wont let me and two the records wouldn't be lined up
right and I would be copying emails to the wrong records!
Do you have any other suggestions? I dont believe I can add a primary key
because they wouldn't be the same for both tables.

Duane Hookom said:
If you want this automated, it requires the identification of a primary or
unique key in each table that can be used to join them in a query. If you
don't have this, you can copy and paste from one to the other.

--
Duane Hookom
Microsoft Access MVP


Caleb said:
Hi I have two customer tables, the first [Master_List] is much older but more
complete, however the newer one [NEWCompleteList] has more up to date email
addresses and fax numbers. I want to build a query that will update all the
Emails and Faxes in the Master_List with the Emails and Faxes in NEWComplete
List, but only for the records in NEWCompleteList that arent Null. This seems
so simple but Im having lots of troubles so any help would be greatly
appreciated. Thanks!
caleb
Click to expand...
Click to expand...
 
You can't automate this as your tables are. By copy and paste, I mean find
the information from one record (one field) and paste it into another record
in the other table.

It's a bit like calling the local deli with sandwich orders from maybe 50
employees at your location. You didn't write down which employee ordered
which sandwich and the orders come in little bags without the "ham on rye"
written on them. You basically have to open each bag, check the contents, and
then yell out "who ordered the turkey!"

If you had written down the names and sandwiches (created a unique index on
employee initials) and the deli had written the contents on the outside of
the bag, then distribution would be much more efficient.
--
Duane Hookom
Microsoft Access MVP


Caleb said:
I dont have a primary or unique key that can identify a record from one list
and the same record from the other, and What do you mean copy and paste? I
cant copy a handfull of emails in access and paste the into another table for
two reasons, one access wont let me and two the records wouldn't be lined up
right and I would be copying emails to the wrong records!
Do you have any other suggestions? I dont believe I can add a primary key
because they wouldn't be the same for both tables.

Duane Hookom said:
If you want this automated, it requires the identification of a primary or
unique key in each table that can be used to join them in a query. If you
don't have this, you can copy and paste from one to the other.

--
Duane Hookom
Microsoft Access MVP


Caleb said:
Hi I have two customer tables, the first [Master_List] is much older but more
complete, however the newer one [NEWCompleteList] has more up to date email
addresses and fax numbers. I want to build a query that will update all the
Emails and Faxes in the Master_List with the Emails and Faxes in NEWComplete
List, but only for the records in NEWCompleteList that arent Null. This seems
so simple but Im having lots of troubles so any help would be greatly
appreciated. Thanks!
caleb
Click to expand...
Click to expand...
Click to expand...
 
You can't automate this as your tables are. By copy and paste, I mean find
the information from one record (one field) and paste it into another record
in the other table.

It's a bit like calling the local deli with sandwich orders from maybe 50
employees at your location. You didn't write down which employee ordered
which sandwich and the orders come in little bags without the "ham on rye"
written on them. You basically have to open each bag, check the contents, and
then yell out "who ordered the turkey!"

If you had written down the names and sandwiches (created a unique index on
employee initials) and the deli had written the contents on the outside of
the bag, then distribution would be much more efficient.
--
Duane Hookom
Microsoft Access MVP


Caleb said:
I dont have a primary or unique key that can identify a record from one list
and the same record from the other, and What do you mean copy and paste? I
cant copy a handfull of emails in access and paste the into another table for
two reasons, one access wont let me and two the records wouldn't be lined up
right and I would be copying emails to the wrong records!
Do you have any other suggestions? I dont believe I can add a primary key
because they wouldn't be the same for both tables.

Duane Hookom said:
If you want this automated, it requires the identification of a primary or
unique key in each table that can be used to join them in a query. If you
don't have this, you can copy and paste from one to the other.

--
Duane Hookom
Microsoft Access MVP


Caleb said:
Hi I have two customer tables, the first [Master_List] is much older but more
complete, however the newer one [NEWCompleteList] has more up to date email
addresses and fax numbers. I want to build a query that will update all the
Emails and Faxes in the Master_List with the Emails and Faxes in NEWComplete
List, but only for the records in NEWCompleteList that arent Null. This seems
so simple but Im having lots of troubles so any help would be greatly
appreciated. Thanks!
caleb
Click to expand...
Click to expand...
Click to expand...
 
Back
Top