Results 1 to 3 of 3
  1. 02-14-2010, 10:15 AM #1
    grad2009
    grad2009 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    27

    how to use dlookup to retrive a value from more than one table

    hello guys,
    can you tell me how to use dlookup function to retrive a value from more than one table.
    i'm looking forward to hearing from you,
    thanks with regard,
    Reply With Quote Reply With Quote
  2. 02-14-2010, 11:40 AM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    DLookup() can only retrieve one value from one table/query. You will need more than one DLookup().
    Reply With Quote Reply With Quote
  3. 02-14-2010, 01:38 PM #3
    grad2009
    grad2009 is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    27
    thanks a lot
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Dlookup Lookup Value
    By WhatnThe in forum Access
    Replies: 14
    Last Post: 12-30-2009, 11:45 PM
  2. How do I get dlookup values to store in table
    By rpmyhero in forum Access
    Replies: 1
    Last Post: 11-25-2009, 05:57 AM
  3. Dlookup
    By janjan_376 in forum Access
    Replies: 20
    Last Post: 07-07-2009, 07:40 AM
  4. Dlookup question
    By nkenney in forum Forms
    Replies: 3
    Last Post: 07-01-2009, 06:36 PM
  5. Need Help for Dlookup function
    By wasim_sono in forum Programming
    Replies: 5
    Last Post: 01-04-2006, 08:18 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums