Search results

Thanks Cheeky - this works perfect.

Not exactly sure where to put them. I've tried them on the other side without success. Can you show me the statement you think will work? Thanks in advance.

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