I have a Table 1-Data containing "Location" & "Name" where location is a Text field containing numbers that all begin with a "0" (example: 0175, 0135, etc). I have a second Table 2-Properties that contains "Effective Date", "Location", "Name" & "Percentage". "Location" on Table 2 is also a Text field. My query is pulling in all fields from Table 1 and I want a DLookup to find the "Percentage" from Table 2. I've tried many times and cannot get it to work. I don't want to join the tables because later on there will be multiple records in Table 2 with the same "Location" but different effective dates that I will later have to use as part of the lookup. Currently I have no duplicates. I cannot get the code to work. The code I have been using follows:
dlookup ("[Properties]![Percentage]","Properties", "[Data]![Location]=" & [Properties]![Location])