Results 1 to 2 of 2
  1. #1
    Perfac is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2016
    Location
    Gauteng Johannesburg
    Posts
    387

    Criteria part in an expression in a query.

    This rookie has done a lot of searching today, but no good result. Just need the exact expression or formula in a calculated field in a query. First query "q03SalaryIncrease". Fields DateFrom, DateTo, Salary, Emp_ID. Second query where I want to add the calculated field. "q01Employees" with fields EmpID, LatestIncrDate. The expression I am trying. Dlookup("[Salary]","q03SalaryIncrease","[Emp_ID]=" & [EmpID] & " And [DateTo]=[LatestIncrDate])
    I believe I simply have it wrong after the "and". Maybe an ampersand, or comma or double quote?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,047
    do NOT use Dlookup in a query. The query IS the dlookup.
    join 2 tables to lookup your item.
    add the calcd field there.

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

Similar Threads

  1. Replies: 1
    Last Post: 06-14-2015, 09:48 AM
  2. Query Criteria Expression
    By Ranger7913 in forum Queries
    Replies: 3
    Last Post: 11-17-2014, 09:49 AM
  3. Replies: 1
    Last Post: 11-13-2014, 11:34 PM
  4. Replies: 8
    Last Post: 08-03-2014, 09:35 PM
  5. Replies: 2
    Last Post: 06-22-2014, 09:49 PM

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