Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Posts
    25

    Unanswered: Dlookup not giving the right value

    I want the Dlookup to show the right value. the Dlookup that I am using it is not giving the right information.
    =Dlookup("Material_Desc","Std","Combo=" & "Combo")

    Material_Desc is a text field
    Std is the table
    Combo is the Unique ID

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You're looking up the literal string "Combo". Perhaps this will help:

    General: DLookup Usage Samples
    Paul

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    =Dlookup("Material_Desc","Std","Combo=" & "Combo")
    To
    =Dlookup("Material_Desc","Std","Combo=" & Combo)

  4. #4
    Join Date
    Nov 2010
    Posts
    84
    =Dlookup("[Material_Desc]","Std","Combo=" & Combo)

Posting Permissions

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