Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2009
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    combining fields from two tables to make third

    Hi all,

    I am trying to combine two tables into one. I have some data in one table that I want to update to another table.

    I semi-successfully created the Make Table query. Problem is, out of 235 records in the two tables, I only get 109 in the combined (make table) table. What can I possibly be doing incorrectly?

    TIA,

    Bret

  2. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    It's very hard to answer without knowing the starting tables and the code for the make table query.

  3. #3
    Lounger
    Join Date
    Jan 2009
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm getting closer. I now get it to return more than half. I went into the Join Properties and played around.

    Here is the sql. SELECT [Wamsutter Complete List].[Procedure Number], [Wamsutter Complete List].[Procedure Title], [Wamsutter Complete List].Determination, [Wamsutter Complete List].[Procedure Type], [Wamsutter Complete List].[Document Owner], [Master List].[Next Review Date] INTO [tbl_Combined with review dates]
    FROM [Wamsutter Complete List] LEFT JOIN [Master List] ON [Wamsutter Complete List].[Procedure Title] = [Master List].[Document Name];

  4. #4
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    Is the join field correct? How many records in each of the tables?

Posting Permissions

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