Results 1 to 2 of 2
  1. #1
    Vicky is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2017
    Location
    India
    Posts
    1

    Dlookup in Access 2007

    Dear Sirs, I have two tables which contains number of files which goes from two levels before reaching client. In table 1 I have level 1st data & in table 2 I have level 2nd data. What I need now is Level 2nd data to be automatically added in table 1 which is different for each file. For example: In table 1 I have File number, User name, User ID & in table 2 I have file no, Editor name, Editor ID. I need to fetch results for every file in one table to have all fields correct i.e. File no (Same in both tables), User name, User ID, Editor name, Editor ID. Can you please help me out?



    Thanks,
    Vicky

  2. #2
    Join Date
    Apr 2017
    Posts
    1,792
    SELECT a.FileNo, b.UserName, b.UserId, a.EditorName, a.EditorID FROM Table2 a LEFT OUTER JOIN Table1 b ON b.FileNo = a.FileNo

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 08-08-2014, 05:22 PM
  2. Replies: 3
    Last Post: 06-17-2013, 05:12 PM
  3. Replies: 2
    Last Post: 06-18-2011, 09:55 AM
  4. Dlookup Problem in Access 2007
    By doquan0 in forum Programming
    Replies: 1
    Last Post: 08-27-2010, 05:41 AM
  5. Replies: 1
    Last Post: 03-18-2010, 09:12 AM

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