Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    65

    Question Unanswered: Can I have two conditions in a DlookUp function?

    I was trying to use two conditions with DlookUp function to pick up specific value from a table and so far can't get the syntax right. I am using something like this:

    Variable = DlookUp ("[Name]", "Addresses", "[Area]" = Me.Area AND "[Color]" = Me.Color)

    "Color" and "Area" are both Integer.

    Any help would be appreicated.
    Jazz

  2. #2
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179
    Variable = DlookUp ("[Name]", "Addresses", "[Area]=" & Me.Area & " AND [Color]=" & Me.Color)

  3. #3
    Join Date
    Feb 2003
    Posts
    65
    Originally posted by JTRockville
    Variable = DlookUp ("[Name]", "Addresses", "[Area]=" & Me.Area & " AND [Color]=" & Me.Color)
    Thank you for your help. I am never sure where to put the notorious """.
    Jazz

Posting Permissions

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