Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Toledo, Ohio, USA
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert Into/Append Qry

    Is there any way using the 'Insert Into' statement that will force the contents of an existing record to be overwritten? I have 2 tables - each keyed by social security number. If, for example, a persons address changes I want the change of address data to be applied in the target table - but since it already contains that SSN the Insert Only operation skips that record. Any ideas? Thanks in advance.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert Into/Append Qry

    Rather than appending a new record, consider using an Update query to update the address fields in the target table.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Toledo, Ohio, USA
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert Into/Append Qry

    Thanks - a combination of both the update query and append query will provide a valid solution to the task I'm trying to accomplish.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •