Results 1 to 2 of 2
  1. #1
    jtolsma is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2012
    Posts
    9

    Question Dlookups with multiple criteria

    For some reason I can not seem to get my lookup worded correctly so I am reaching out for help. Let me try to explain what I am trying to do.
    I am building a form and would like for it to do a dlookup based on Employee Number and Date in an Attendance Table. (For each empnum there will be multiple dates, and vice versa). In the Attendance there is a field called points, and that is what I am trying to look up.
    So, after I enter the EMPNUM and DATEofOccurance in my Warning form, I would like it to pull the Points from the Attendance Table (with the corresponding EMPNum and Date) and put them in the Form.
    Again, I don't know why I am struggling so much with this, but I would really appreciate any help. ( I hope I explained this well.)


    Jessica

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Hard to know what you're doing wrong if you don't post your failing effort.

    See if the multi-criteria example here helps:

    DLookup Usage Samples
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Multiple criteria lookup
    By rchtan in forum Queries
    Replies: 4
    Last Post: 01-18-2012, 12:21 AM
  2. Replies: 3
    Last Post: 10-18-2011, 03:08 PM
  3. Dlookups
    By funkygoorilla in forum Access
    Replies: 12
    Last Post: 09-28-2011, 08:35 PM
  4. Iif statement with multiple criteria
    By coach32 in forum Queries
    Replies: 1
    Last Post: 09-07-2011, 01:28 AM
  5. Replies: 1
    Last Post: 07-13-2011, 11:00 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