Search results

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...