+ Reply to Thread
Results 1 to 3 of 3

Access: Using two tables in a query using a "Dlookup"

  1. #1
    Registered User
    Join Date
    12-19-2013
    Location
    Putnam Valley, New York
    MS-Off Ver
    Excel 2007
    Posts
    8

    Access: Using two tables in a query using a "Dlookup"

    I'm used to vlookups in excel, but it does not seem so easy in access. I'm trying to add a column in a query using a dlookup. I have brought in two tables T1 has all possible ID numbers and the business names, T2 has the expenses by ID. I want a formula that give me the business name in a column in my query. In simple terms: lookup the id in t2 row, t1, should give me the business name.
    Last edited by mirving; 06-18-2015 at 04:54 PM.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,172

    Re: Access: Using two tables in a query using a "Dlookup"

    DO NOT use Dlookup in a query. You are doubling the work. The query itself is the lookup.
    Just join the 2 tables and it will join the results.

  3. #3
    Registered User
    Join Date
    12-19-2013
    Location
    Putnam Valley, New York
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Access: Using two tables in a query using a "Dlookup"

    Wow! I was really over thinking that. It's my first time putting a database together, so I'm grateful for shortening my learning curve.

    Thanks so much

    Mirving

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 06-06-2013, 06:28 PM
  2. Run "Make Table" Query in Access from Excel VBA
    By NickOn in forum Access Tables & Databases
    Replies: 7
    Last Post: 05-31-2012, 12:58 AM
  3. [SOLVED] Trying to "automate" inserting record numbers in Access 2010 query
    By alcharbonneau in forum Access Tables & Databases
    Replies: 7
    Last Post: 05-18-2012, 01:03 PM
  4. Replies: 2
    Last Post: 06-26-2007, 02:55 PM
  5. Microsoft Query rejects "nz" function in Access Query
    By Vaughan in forum Excel General
    Replies: 0
    Last Post: 05-04-2005, 01:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1