If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#19
|
|||
|
|||
Membership database updates
On Fri, 21 Mar 2008 12:21:01 -0700, Pennington
wrote: I have encountered a problem. When I run the Append Query it adds new members to the Members Table and does not add duplicates which is fine but I want to also update the Members Table where the data in a field is different (The Primary Key will not change but titles, addresses and e-mails may change). I have looked at an Update Query but this is not appropriate. What other type of query can I use for this? In what way is an update query inappropriate? If you want to update existing records from a second table matching by primary key, an Update Query is exactly what you would use! -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|