jeffatwork
New member
- Local time
- Today, 12:59
- Joined
- Sep 20, 2022
- Messages
- 4
Im attempting to do a Dlookup in a query where there are 2 criteria for the lookup. Attached is a snapshot of the 2 tables I'm working with. I can get it to work with single criteria, but when I add the 2nd criteria (where), it doesnt work. I realize DMax is likely the solution and this specific query will only return "matching" items, but I'm just attempting to simplify my explanation of the problem. The Dlookup I'm using with 2 criteria, which doesnt work is:
DLookUp("Score","AFF","[start]=" & [Resid] And "[HH_Size]=" & [HHS])
DLookUp("Score","AFF","[start]=" & [Resid] And "[HH_Size]=" & [HHS])