Results 1 to 5 of 5
  1. #1
    julessantana is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    7

    Question DLookup in a table?


    Is it possible to use the dlookup function within the table in Access, similar to how vlookup is used in Excel?

    I have figured out how to use it in a form, but can't figure out how to do it in the table itself.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    No - use query.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    julessantana is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    7
    Is it not possible, or just not recommended?

    I don't know how to do a dlookup in a query. Can I base queries off of queries? Because I'm going to need one massive query that would have all of my POs listed, and the additional dozen fields that I need to look up, and then I'm going to need to base many queries off of that. That's just... dumb.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    Not possible.

    Yes, queries can be referenced like tables in queries.

    Not dumb, that is relational database.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Not dumb, not excel

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

Similar Threads

  1. Dlookup Value not saving in table
    By memento in forum Forms
    Replies: 9
    Last Post: 08-15-2014, 05:54 AM
  2. Replies: 1
    Last Post: 03-22-2013, 03:33 AM
  3. Replies: 4
    Last Post: 05-09-2012, 07:20 AM
  4. Replies: 1
    Last Post: 10-20-2011, 07:37 AM
  5. Replies: 1
    Last Post: 08-13-2011, 12:03 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