lookup value in query

• Question

• 

  

  0

  Sign in to vote

  I have two table one is named Staff and other named Items. I created query named queryStaff which link both of them using relationship. I intended to DLookUp specific field in query not from Table e.g in report I used this function  = DLookup("field name", "queryStaff "). is this possible because I discovered that normally we used to DLookup value from table. please helps

  • Moved by Carey FrischMVP, Editor Friday, June 12, 2015 5:35 PM Relocated

  Friday, June 12, 2015 1:41 PM