Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    Stan Denman is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    50
    This code to accomplish the task:

    INSERT INTO tblClients ( ContactID, SSN, ClientMailingAddr, City, State, Zip )
    SELECT tlbCont.ContactID, TempData.ClientSSN, TempData.ClientMailingAddr1, TempData.ClientMailingAddrCity, TempData.ClientMailingAddrState, TempData.ClientMailingAddrZip


    FROM TempData INNER JOIN tblCont AS tlbCont ON (TempData.LastName = tlbCont.LastName) AND (TempData.First = tlbCont.FirstName);

    Yes you are so right - as I am identifying missing clients and repeating the process I have the risk of creating duplicate records. When Ichange the join to "OUTER JOIN" however I get "syntax error in FROM clause"

  2. #17
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,087
    You need to make both joins (for first and last name) have the arrow point towards the target table (tblClients) then add two fields from tblClients to the Select statement and add in the criteria row for each Is Null (make sure there row Append To stays empty for these).
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  3. #18
    Stan Denman is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    50
    I'm sorry. I remain pretty confused. Here is what I have so far. thank you again for your help. I am just going to do it by hand. I would have had it done by now. MS Access always succeeds in disappointing me.
    Attached Files Attached Files

  4. #19
    Stan Denman is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    50
    I don't understand how Dmax is keeping the ContID straight.

  5. #20
    Stan Denman is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    50
    OK. never mind. ChatGPT solved it for me!

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import Linked Outlook Tasks Folder Doesn't Import All Data
    By Bkper087 in forum Import/Export Data
    Replies: 0
    Last Post: 11-19-2019, 12:06 AM
  2. Replies: 6
    Last Post: 09-08-2019, 03:18 PM
  3. Replies: 1
    Last Post: 07-09-2017, 11:14 PM
  4. Replies: 2
    Last Post: 02-28-2017, 01:34 AM
  5. Replies: 13
    Last Post: 01-25-2016, 01:36 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums