How to get get data from one table to another?

[thadson]

Hi,

I have 2 tables "customers" and "cancel"

the cancel table comes from a third party.

Customers table has CustID CustName SignupDate CancelDate CancelReason

CancelTable has CustID CancelDate CancelReason RoomCode Promocode

As the Customers table is the original Table it contains no cancel info yet.

I would need to get the CancelDate and CancelReason info into the customers table but I can not figure out a way to do it.

UpdateQueries let me only put in 1 certain data but not the variety that is in my cancel table...

Sorry, but i'm not a database programmer and I do not have much resources...

 

[Fuga]

Hi,

I think you should use an update query.

UpdateQueries let me only put in 1 certain data but not the variety that is in my cancel table...

How do you mean?

Fuga.

 

[thadson]

update query

like i can update all the customers cancel date to let say 8/21/03 at the same time but I want to use the data that is in the cancel table:

how can i update customer1's CancelDate field in the customers table to 8/21/03 from the cancel table and
customer2's to 8/3/03 and
customer3's to 7/5/03 and
customer4 needs no update
customer5's to 8/29/03 and so on with a single query?

 

[Fuga]

You create an update query with a join on the two custID fields.

Then, in the "update to" row of the canceldate field, put [canceltable].[canceldate]

The join makes it so that the right customer gets the right canceldate.

Make a backup though, just in case.

Fuga.

 

[thadson]

did not work

Thanks, apprecieate the help.
However it did not work,
I did the tings you have said and it just does nothing.. not even an error message.
However the records are not updating.

 

[SforSoftware]

Can you attach a copy of the database?
It must work in the way Fuga declared...

 

[thadson]

thanks, I got it... I needed a "!" instead of a "." between the fields.

Thank you