Updating Data in a Table by Calling on Another Table

Jerh9e1k5

Hi there!

I'm trying to organize data into single line exports in order to take it out of a database.
The database contains customer information. Some customers have more than one "Business" phone number. I've managed to divide up the phone numbers into "Business" and "Business2" through a query which I then transformed into a table.

Now I want to use this new table to update the master table. Keep in mind that not all instances of "Business" have to be changed to "Business2".

How can I go about doing this?

Thanks for the help! :D

nico5038

Quote:

Originally Posted by Jerh9e1k5

Hi there!

I'm trying to organize data into single line exports in order to take it out of a database.
The database contains customer information. Some customers have more than one "Business" phone number. I've managed to divide up the phone numbers into "Business" and "Business2" through a query which I then transformed into a table.

Now I want to use this new table to update the master table. Keep in mind that not all instances of "Business" have to be changed to "Business2".

How can I go about doing this?

Thanks for the help! :D

I have a hard time to see what you need.
Looks to me your new table holds all needed data thus I wonder why you need to put in back into the "main" table.

Nic;o)

Updating Data in a Table by Calling on Another Table

re: Updating Data in a Table by Calling on Another Table

/bytes/development

/bytes/it

/bytes/about