 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2005Update one table with the contents of another
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  SignatureIf I answered your question, please mark it as an answer. That way, it will stay saved for a longer time, so other can benefit from it. Good luck > 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? When one table is to be kept stored separately for audit purposes. -- If I answered your question, please mark it as an answer (though I can't say where you would do that <g>). 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. > > What are the reason to keep two tables that holds the same data? > [quoted text clipped - 3 lines] > If I answered your question, please mark it as an answer (though I > can't say where you would do that <g>). > I know of some reasons to keep the same data in two tables. 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 > > I know of some reasons to keep the same data in two tables. > > 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." 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. SignatureBrendan Reynolds > Many times there are questions that been asked before, I remember > answering [quoted text clipped - 21 lines] >> an answer" in your sig line mean? BTW it contains a typo. I think it >> should read, "... so Ofer can benefit from it." > 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 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) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.