Results 1 to 3 of 3
  1. #1
    jppevy is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2013
    Posts
    7

    relationships across sheets

    I am new to access, so this is an entry level question.

    If I have two sheets: one with employee information of say 500 cells, each marked by a unique ID. I have another sheet with about 50 cells, with some of the same employees and their vacations days. The second sheet has the same IDs as the first sheet, of course. IF I want to create a new sheet, or at least combine the data from the second sheet into a new column in the first: How do I do this? Again, the first sheet has all employees, and the second only some. Below should help explain this visually.

    Table 1


    Emp ID name
    1 John
    2 Sarah
    3 Tim

    Table2
    Emp ID vacation days
    3 14
    17 20
    80 10



    Thanks again!

  2. #2
    Dal Jeanis is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    Are you talking about Excel, rather than Access?

    In Excel, I'd select the area on the second (optional) sheet, make that area a named table, and use the VLOOKUP function in cells on the first sheet to populate data from the second sheet.

    In Access, you wouldn't **combine** the two tables, you'd just LEFT JOIN them into the query whenever the data was relevant.

    Start a new query in query design view.

    Add the two tables.

    If the relationship is not already there, drag a line between the key field of each table.

    Now, right-click the relationship, and set the relationship type to include all the records on the "name" table, and only the matching records from the "vacation" table.

    Now you have a query that you can use to make reports.

  3. #3
    jppevy is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2013
    Posts
    7
    solved. thanks!

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

Similar Threads

  1. Reports from sub-data sheets
    By sdc1234 in forum Reports
    Replies: 1
    Last Post: 06-11-2013, 09:42 PM
  2. Inporting Summary Sheets
    By Kapelluschsa in forum Import/Export Data
    Replies: 3
    Last Post: 08-13-2010, 02:01 AM
  3. Export to excel different sheets
    By apsf68 in forum Access
    Replies: 2
    Last Post: 07-27-2010, 07:05 AM
  4. How many sheets of paper do I need?
    By carstenhdk in forum Reports
    Replies: 1
    Last Post: 05-10-2010, 06:36 AM
  5. export table to multiple sheets
    By TheShabz in forum Import/Export Data
    Replies: 5
    Last Post: 04-06-2010, 02:59 PM

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