Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
  1. #16
    ruiter is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2016
    Posts
    12
    This is the original query in SQL view:
    SELECT TITLE.nr, TITLE.art1, TITLE.title1, Tracks.Tr_Prefix, Tracks.Tr_Nr, Tracks.Tr_Cd, Tracks.Tr_Tracknr, TITLE.ISRC
    FROM TITLE INNER JOIN Tracks ON TITLE.nr = Tracks.Tr_TrackIDnr
    ORDER BY Tracks.Tr_Nr, Tracks.Tr_Cd, Tracks.Tr_Tracknr;
    I called the linked table in Access: Catalogrequest
    The field -- it won't let me change it on a linked table so it's just called F1

  2. #17
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    OK. Create a new query, go to SQL View, and post this SQL code in there.
    Code:
    SELECT TITLE.nr, TITLE.art1, TITLE.title1, Tracks.Tr_Prefix, Tracks.Tr_Nr, Tracks.Tr_Cd, Tracks.Tr_Tracknr, TITLE.ISRC
    FROM TITLE 
    INNER JOIN Tracks 
    ON TITLE.nr = Tracks.Tr_TrackIDnr
    INNER JOIN Catalogrequest
    ON Tracks.Tr_Nr = Catalogrequest.F1
    ORDER BY Tracks.Tr_Nr, Tracks.Tr_Cd, Tracks.Tr_Tracknr;
    Note that all I did was take your original query and added in your linked table, so it should only return the records matching the Tr_Nr numbers in your Excel list.

  3. #18
    ruiter is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2016
    Posts
    12
    I will try this out very soon (my nephew just arrived)... I am soooo grateful for your help, Joe!! It looks like I need a class in SQL (among other things). I'll let you know how it goes, probably tomorrow!

  4. #19
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You are welcome.

    It looks like I need a class in SQL (among other things)
    I would recommend starting out with Access first, and then moving to SQL. SQL is a part of query writing which is just a small (but technical) part of Access. With the Access visual Query Builder, you can use Access without every really learning how to write SQL code (though it can be helpful to learn). Where it is helpful here is I can help you build your query by passing you the actual code, instead of trying to describe how to put everything together in the Query Builder. After you paste the SQL code in there, you can switch the Views again and see what it looks like in the visual Query Builder.

  5. #20
    ruiter is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2016
    Posts
    12
    And, again, thanks Joe. I will try out an Access class at some point for sure. I have been pretty good about learning what I needed to until this issue, and so it's time for it! I tried to put the SQL code in and I got a syntax error, please see attached screen shot...
    Attached Thumbnails Attached Thumbnails Screenshot - 4_30_2016 , 10_32_47 AM.png  

  6. #21
    ruiter is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2016
    Posts
    12
    Hi again Joe, I spent some time on the internet and the syntax and other error messages seem to have been caused by missing parentheses in the SQL code. I don't know why the errors didn't appear in my original code which also apparently missed the parentheses. BUT the good news is that it appears to be working. YAY! I again send sincerest thanks for your assistance!

  7. #22
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Excellent! Glad we got it working.

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

Similar Threads

  1. Replies: 1
    Last Post: 12-22-2015, 11:13 AM
  2. Replies: 4
    Last Post: 04-29-2014, 04:33 AM
  3. Replies: 4
    Last Post: 12-19-2013, 01:18 PM
  4. SQL Update query using data in Excel column
    By tylerg11 in forum SQL Server
    Replies: 2
    Last Post: 09-03-2013, 05:10 PM
  5. Paste Data From Excel To Access Form
    By fanzak in forum Programming
    Replies: 2
    Last Post: 08-16-2010, 02:40 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