Ask Experts Questions for FREE Help !
Ask
    bagic's Avatar
    bagic Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jun 21, 2008, 12:05 PM
    Linking two worksheets into another worksheet in ms access
    I want to work in access to link two different worksheets in which there is common field and the result should be shown in third worksheet
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Jun 21, 2008, 01:20 PM
    You can link a worksheet within Access. You can then create a query that links the two on the key field. But you don't need a 3rd spreadhseet, just the query.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Link worksheets? [ 1 Answers ]

How can I link one data worksheet to another worksheet . Basically I want a one sheet is my daily working sheet and another worksheet month base record please help what can I do for my daily base and month base record in single intery update and after that both sheet update

Excel Worksheets [ 1 Answers ]

I have several worksheets in an Excel spreadsheet. Is there a way that I can print a list of the names of each of the worksheets in the spreadsheet?

Worksheets within the same workbook [ 21 Answers ]

Hi, I have many worksheets within the same file, what I really want is to have either a (link / go to option) from sheet1 to other sheets without using hyperlink because I want to send to others. Example: if I click on Apple from Sheet 1, I will go to Sheet2 Sheet1 Sheet2 ...

Protected worksheets [ 3 Answers ]

When you protect a worksheet in excel but unprotect certain cells, why can't you change the format of the cells or insert comments?

Excel: Linking from one worksheet to another [ 8 Answers ]

I'd like to link from a cell in one worksheet to a LINE in another. If that doesn't make sense, I've got a member list of people with address, phone, etc. For folk that have not renewed this year, I want to have a separate worksheet that documents my contact efforts... so to link from the...

View more questions Search