By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Updating Data in a Table by Calling on Another Table

P: 1
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
Dec 21 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
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)
Dec 31 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.