Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628

    Unanswered: Need a little help with a DLookup statement.

    Hi all, im needing a bit of help constructing a DLookup statement. Here's what im trying to do:

    Lookup the FirstName field on the Employees table where the EmployeeID on the Employees table and the User value on the Config table match.

    I know it sounds more like a query, but i can't seem to be able to get it to work right.

    If anyone can help, i'd really appreciate it.

    Thanks!

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Make a query including your both tables, name it userInfo for example then you can use
    anyVariable= DLookup ("userName", "UserIffo", "yourCondition without Where"

Posting Permissions

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