I'm building a report that has monthly metrics to track performance. I'm having an issue with a DLookup field.
The field should match the AgentID and the Date fields. I verified that the Agent ID and Date fields match on the tables.
Here's my query, but it only returns an error message.
Code:AHT Seconds: DLookUp("AHT_Seconds","tblAHTDaily","[AgentID_AHT] =" & [AgentID_Unplanned] & "' And [AHT_Date] = '" & [Unplanned_Date] & "'")