Update one table with the contents of another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables holding address details. Once details have been input into
table 1 I wish to update table 2 with the same data where 'Yes' is chosen
in the 'Update Address' field. Would this be done by using an append
query? Or an update query? and if so, how?

Many thanks
 
What are the reason to keep two tables that holds the same data?

To answer your question, I would create two queries:
1. Append query, that append all the data in table1 that is not in tabl2
Use the query wizard to create UnMatch records query
2. Update query to update the identical records
 
I know of some reasons to keep the same data in two tables.
Citybird reasons for keeping two tables could be solved by an extra select
query instead.
 
Ofer said:
I know of some reasons to keep the same data in two tables.
Click to expand...

But to answer my (admittedly oblique) question, what does "mark it as
an answer" in your sig line mean? BTW it contains a typo. I think it
should read, "... so Ofer can benefit from it."
 
Many times there are questions that been asked before, I remember answering
them, but I can't tell iif it was the right answer so I can give the same
reply.

The messages that are not marked as an answer been deleted after a period of
time, so I can't refer to them.
I don't know which benefit you think I'm getting from it, I didn't get a car
or a single Dollar for each answer that I gave.
I do anjoy seeing that I answer correctly, and this is the biggest reward
I'm getting.

No body knows where I leae or who I am, no body will care if I'll stop
posting here, except me.
So if you call, feeling good if answer been marked as Yes, is Ofer benefit,
then I'm guilty
 
Possible source of confusion here ... all this 'mark as answer stuff' only
makes sense to those who use Microsoft's web-based interface. It all looks
rather odd to the rest of the world. And answers that may no longer be
visible on Microsoft's web page are still very much available in the Google
newsgroup archives at www.google.com/groups

Don't get me wrong - it doesn't particularly bother me or anything. Just
pointing out that different people have different views onto the newsgroups.
 
Brendan said:
Possible source of confusion here ... all this 'mark as answer stuff' only
makes sense to those who use Microsoft's web-based interface. It all looks
rather odd to the rest of the world. And answers that may no longer be
visible on Microsoft's web page are still very much available in the Google
newsgroup archives at www.google.com/groups
Click to expand...

Thanks Brendan, that explains it for me.
 
Now I can see how the rest of the world can see the post, and I agree
that it can raise a question.

I do enjoy this Discussion group, and in the last few months, since I
joined this group, I've been spending few houres a day, It's drive my
wife crazy, and I got a little diffensive when some one accuse me of
getting benefit from it.

I love it, when someone reply and say "thank you" or anything else, but
most people don't reply.

In my work there is a limit of sites that I can access, and Microsoft
is one of them.
I'm always refering to post that were given there, by me, or by others,
but the problem with, tha post six month old that weren't mark as an
answer, are deleted.

Any way, I'm talking to much.
Sorry to you and all the others that think that I'm wrong by doing
that, but it is important to me.
Ofer (I'm not english speaker, so forgive my spelling and grammer
mistakes)
 
Back
Top